Is it possible to view Oracle user table privilege

问题:

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.

回答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

回答2:

See me what GRANTs and Privileges I have:

SELECT * FROM user_tab_privs;

回答3:

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.

回答4:

DBA_TAB_PRIVS DBA_SYS_PRIVS DBA_ROLE_PRIVS

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