Skip to Main Content

Oracle Database Discussions

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!

GRANT INSERT ON TABLE - Oracle 11g

user633278Feb 25 2012 — edited Feb 25 2012
Hi

I have a user in Oracle which I have granted the insert command on a table using GRANT INSERT ON ACCOUNTS TO INSERTUSER;

The grant was successfully granted and there is no problem when inserting data into the table when logging in as that user. My problem is when testing the privilege that it is still possible to run the select command as that user. Therefore, how do I only ensure that this user is only able to insert into this table and not able to select from it? Further, the insert is running under a stored procedure, and I have granted the permission to run execute on that procedure.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2012
Added on Feb 25 2012
4 comments
9,607 views