如何查询oracle当前用户权限的授予人，或者当前用户给其他用户授予过的权限
发布网友
发布时间：2022-04-22 09:46
共1个回答
热心网友
时间：2023-10-30 19:25
有下面这些权限表，你自己研究一下：
SQL>
select * from dictionary where table_name like '%PRIVS%';
TABLE_NAME COMMENTS
-------------------- ----------------------------------------
ALL_COL_PRIVS Grants on columns for which the user is
the grantor, grantee, owner,
or an enabled role or PUBLIC is the gra
ntee
ALL_COL_PRIVS_MADE Grants on columns for which the user is
owner or grantor
ALL_COL_PRIVS_RECD Grants on columns for which the user, PU
BLIC or enabled role is the grantee
TABLE_NAME COMMENTS
-------------------- ----------------------------------------
ALL_TAB_PRIVS Grants on objects for which the user is
the grantor, grantee, owner,
or an enabled role or PUBLIC is the gra
ntee
ALL_TAB_PRIVS_MADE User's grants and grants on user's objec
ts
ALL_TAB_PRIVS_RECD Grants on objects for which the user, PU
BLIC or enabled role is the grantee
TABLE_NAME COMMENTS
-------------------- ----------------------------------------
DBA_AQ_AGENT_PRIVS
DBA_COL_PRIVS All grants on columns in the database
DBA_ROLE_PRIVS Roles granted to users and roles
DBA_RSRC_CONSUMER_GR Switch privileges for consumer groups
OUP_PRIVS
DBA_RSRC_MANAGER_SYS system privileges for the resource manag
TEM_PRIVS er
DBA_SYS_PRIVS System privileges granted to users and r
oles
TABLE_NAME COMMENTS
-------------------- ----------------------------------------
DBA_TAB_PRIVS All grants on objects in the database
USER_AQ_AGENT_PRIVS
USER_COL_PRIVS Grants on columns for which the user is
the owner, grantor or grantee
USER_COL_PRIVS_MADE All grants on columns of objects owned b
y the user
USER_COL_PRIVS_RECD Grants on columns for which the user is
the grantee
TABLE_NAME COMMENTS
-------------------- ----------------------------------------
USER_ROLE_PRIVS Roles granted to current user
USER_RSRC_CONSUMER_G Switch privileges for consumer groups fo
ROUP_PRIVS r the user
USER_RSRC_MANAGER_SY system privileges for the resource manag
STEM_PRIVS er for the user
USER_SYS_PRIVS System privileges granted to current use
r
TABLE_NAME COMMENTS
-------------------- ----------------------------------------
USER_TAB_PRIVS Grants on objects for which the user is
the owner, grantor or grantee
USER_TAB_PRIVS_MADE All grants on objects owned by the user
USER_TAB_PRIVS_RECD Grants on objects for which the user is
the grantee
ROLE_ROLE_PRIVS Roles which are granted to roles
ROLE_SYS_PRIVS System privileges granted to roles
ROLE_TAB_PRIVS Table privileges granted to roles
SESSION_PRIVS Privileges which the user currently has
TABLE_NAME COMMENTS
-------------------- ----------------------------------------
set
GV$ENABLEDPRIVS Synonym for GV_$ENABLEDPRIVS
V$ENABLEDPRIVS Synonym for V_$ENABLEDPRIVS
已选择30行。
SQL>
