查询所有系统权限(system_prvilege_map)
select * from system_prvilege_map order by name;
查询所有角色(dba_roles)
select * from dba_roles;
查询所有对象权限(dba_tab_prvis)
select distinct privilege from dba_tab_prvis
查询数据库表空间
select tablespace_name from dba_tablespaces;
查询某个用户具有什么角色(dba_role_privs)
select * from dba_role_privs where grantee='用户名';
查看角色有哪些系统权限
select * from dba_sys_privs where grantee='DBA';
或
select * from role_sys_privs where role='BDA';