Query DBA_ROLE_PRIVS, ROLE_TAB_PRIVS for Name of the object, Privilege granted,Was admin option granted
SQL> select
4 ROLE_TAB_PRIVS.Table_Name, /*Name of the object*/
5 ROLE_TAB_PRIVS.Privilege, /*Privilege granted*/
6 ROLE_TAB_PRIVS.Grantable /*Was admin option granted?*/
7 from DBA_ROLE_PRIVS, ROLE_TAB_PRIVS
8 where DBA_ROLE_PRIVS.Granted_Role = ROLE_TAB_PRIVS.Role
9 and DBA_ROLE_PRIVS.Grantee = 'some username';
SQL>
SQL>
SQL>
Related examples in the same category