Is it possible to view Oracle users roles without having DBA Privilege?

Question

Is it possible to view the roles of the user without having DBA Privilege? If so, how?

SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE = 'USER_NAME';

The above query needs the "SELECT_CATALOG_ROLE" role.

I need to get the result of the above query without (DBA and SELECT_CATALOG_ROLE) Privileges.

Answer 1

Perhaps ALL_TAB_PRIVS will provide what you want. Apparently, it contains:

Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee

Answer 2

You could have the DBA create a new role and grant the new role select on the table. The DBA could then grant you the new role which will allow you to see the table without DBA or select catalog role.