是否可以在没有DBA权限的情况下查看用户的角色？如果是这样,怎么样？
SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE = 'USER_NAME';
上述查询需要“SELECT_CATALOG_ROLE”角色.
我需要在没有(DBA和SELECT_CATALOG_ROLE)权限的情况下获得上述查询的结果.
解决方法@H_403_10@
也许ALL_TAB_PRIVS会提供你想要的东西.显然,它包含：
Grants on objects for which the user is the grantor,grantee,owner,or an enabled role or PUBLIC is the grantee
Grants on objects for which the user is the grantor,grantee,owner,or an enabled role or PUBLIC is the grantee
