关键字:
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;