Query DBA_ROLE_PRIVS, ROLE_TAB_PRIVS for Name of the object, Privilege granted,Was admin option granted : dba_role_privs « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. dba_role_privs

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>