Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unable to insert data into a table

rhisinghJun 18 2014 — edited Jun 26 2014

Hay guys this might sound strange but I have created a table in SQL workshop and when I tried to insert data into this table in the SQL workshop GUI it gave me this error error ORA-01950: no privileges on tablespace 'USERS'  .  So I think I would have to grant myself some privileges like so grant select, insert, update, delete on mytable1 to rhisingh;   . Which I tried in SQL workshop on APEX but it comes back statement not ended properly . Where and how should i execute this grant as in SQL workshop or should i SQL plus into the DB to do this relative to my user name . Thanks Guys  

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 24 2014
Added on Jun 18 2014
7 comments
5,279 views