Query DBA_ROLE_PRIVS, ROLE_TAB_PRIVS for Recipient of the grant,Owner of the object : dba_role_privs « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. dba_role_privs

Query DBA_ROLE_PRIVS, ROLE_TAB_PRIVS for Recipient of the grant,Owner of the object

 
SQL> select
  2        DBA_ROLE_PRIVS.Grantee,        /*Recipient of the grant*/
  3        ROLE_TAB_PRIVS.Owner          /*Owner of the object*/
  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

1.Query user granted roles
2.Query DBA_ROLE_PRIVS, ROLE_TAB_PRIVS for Name of the object, Privilege granted,Was admin option granted
3.Query dba_role_privs table