oracleDBA使用的几个基本语句

--一个用户所拥有的角色

select granted_role from dba_role_privs where grantee='DBA';

---一个角色所包含的系统权限

select * from dba_sys_privs where grantee ='DBA'

--select * from role_sys_privs where role='RESOURCE';

--SELECT ROLE ,COUNT(*) FROM ROLE_SYS_PRIVS GROUP BY ROLE;

--一个角色所包含的对象权限

select * from dba_tab_privs where grantee='DBA'

--一个用户具有的权限

select * from dba_sys_privs where grantee IN (select granted_role from dba_role_privs where grantee='DBA');

--所在数据库名称

select * from global_name; 

---oralce 中有多少角色

select * from dba_roles;

---oracle 中的系统权限

select * from system_privilege_map order by name;

--oracle 中的对象权限

select distinct privilege from dba_tab_privs;