查询oracle权限

 

关键字：

oracle privelege role 

1.role角色

select * from dba_role_privs;

----select * from user_role_privs;

role的进一步细化：

1)role所包含的role

select * from role_role_privs;

2)role所包含的系统权限

select * from role_sys_privs;

3)role所包含的系统权限

select * from role_tab_privs;

2.system privilege系统权限

select * from dba_sys_privs;

----select * from user_role_privs;

 

3.object privelege对象权限

select * from dba_tab_privs;

----select * from user_tab_privs;