How to revoke SELECT permission on a table for a specific user?
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