Skip to Main Content

SQL Developer

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!

How to revoke SELECT permission on a table for a specific user?

garywickeApr 24 2012 — edited Apr 27 2012
Environment:

SQL*Developer 3.1 on Windows XP Pro SP3 connecting to Oracle 11.2.0.3 EE on Solaris 10.5.

I have table T with SELECT privilege granted on it to both a role and a specific user.

I am trying to use SQL*Developer to revoke the SELECT privilege on this table from the individual user and leave it on the role.

I can see how to revoke it from the role by doing a right click on the table and going to Privileges -> Revoke but I can't find where to pick a specific user to revoke from.

Any help is greatly appreciated!!

-gary
This post has been answered by Gary Graham-Oracle on Apr 24 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2012
Added on Apr 24 2012
5 comments
4,953 views