是否可以在没有DBA特权的情况下查看Oracle用户表特权? [英] Is it possible to view Oracle user table privileges without having DBA privilege?

问题描述

是否可以在没有DBA特权的情况下查看用户的角色?如果可以，怎么办?

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';

上面的查询需要"SELECT_CATALOG_ROLE"角色.

The above query needs the "SELECT_CATALOG_ROLE" role.

我需要获得没有(DBA和SELECT_CATALOG_ROLE)特权的上述查询的结果.

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

推荐答案

也许ALL_TAB_PRIVS将提供您想要的东西.显然，它包含:

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

对对象的授予，这些对象的用户是授予者，被授予者，所有者或已启用角色，或者PUBLIC是被授予者

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

这篇关于是否可以在没有DBA特权的情况下查看Oracle用户表特权?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！