Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>