Is it possible to view Oracle user table 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

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.

Answer 2

DBA_TAB_PRIVS DBA_SYS_PRIVS DBA_ROLE_PRIVS

Here are the main tables you can check for roles and privs

Answer 3

See me what GRANTs and Privileges I have:

SELECT * FROM user_tab_privs;

Answer 4

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