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>