如何在Oracle中查找授予用户的特权和角色? [英] How to find the privileges and roles granted to a user in Oracle?

问题描述

我正在使用Linux，Oracle10g. 我已经创建了一个名为test的用户.并授予创建会话的权限，并为该用户选择任何词典权限.

I am using Linux, Oracle10g. I have created one user called test. and granted create session and select any dictionary permission to the same user.

我还向同一用户授予了sysdba和sysoper角色.

i also granted sysdba and sysoper roles to the same users.

现在，我想显示授予用户的所有特权和角色. 我发现以下查询，但它仅显示创建会话和选择字典权限.

Now i want to display all the privileges and roles granted to the user. I found following query but it shows only create session and select dictionary privileges.

select privilege 
from dba_sys_privs 
where grantee='SAMPLE' 
order by 1;

请帮助解决该问题.

谢谢

推荐答案

查看 http://docs.oracle.com/cd/B10501_01/server.920/a96521/privs.htm#15665

使用这些选择语句检查USER_SYS_PRIVS，USER_TAB_PRIVS，USER_ROLE_PRIVS表

Check USER_SYS_PRIVS, USER_TAB_PRIVS, USER_ROLE_PRIVS tables with these select statements

SELECT * FROM USER_SYS_PRIVS; 
SELECT * FROM USER_TAB_PRIVS; 
SELECT * FROM USER_ROLE_PRIVS;

这篇关于如何在Oracle中查找授予用户的特权和角色?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！