If you grant a privilege to Table T "with grant option" to user1, who in turns grant privilege to user2, will user2 lose the privilege automatically if you revoke the privilege from user1?
Printable View
If you grant a privilege to Table T "with grant option" to user1, who in turns grant privilege to user2, will user2 lose the privilege automatically if you revoke the privilege from user1?
Object vs system privileges - objects are revoked, system privs stay in effect.
Does the ALL_TAB_PRIVS system table provide information on the privileges?
Select * from dictionary
where table_name = 'ALL_TAB_PRIVS';