dba_sys_privs
dba_tab_privs
dba_role_privs
system_privilege_map
[@more@]
1.查看用户或角色系统权限：
select * from dba_sys_privs;
select * from user_sys_privs;
2.查看用户对象权限：
select * from dba_tab_privs;
select * from all_tab_privs;
select * from user_tab_privs;
3.查看所有角色：
select * from dba_roles;
查看用户或角色所拥有的角色：
select * from dba_role_privs;
select * from user_role_privs;
4.查看Oracle提供的系统权限
select name from sys.system_privilege_map
5.查看一个用户的所有系统权限(包含角色的系统权限)
select privilege from dba_sys_privs where grantee='USER_NAME'
union
select privilege from dba_sys_privs where grantee in (select granted_role from dba_role_privs where grantee='USER_NAME' );
6.用户如果要使用 v$mystat v$session 等视图，需要给select_catalog_role权限
SQL> grant SELECT_CATALOG_ROLE to ww;
7.查询当前用户的跟踪文件
select TRACEFILE
from v$process
where addr=(select paddr from v$session where sid=userenv('sid'));
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/271063/viewspace-1057947/ ，如需转载，请注明出处，否则将追究法律责任。
