dba_role_privs « System Tables Views « Oracle PL / SQL






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, ROLE_TAB_PRIVS for Recipient of the grant,Owner of the object
4.Query dba_role_privs table