1.查看scott用户的默认表空间、临时表空间
selectusername,default_tablespace,temporary_tablespace
from dba_users
where username ='SCOT';
2.查看scott用户的系统权限
select *
from dba_sys_privs
where grantee = 'XCY';
3.查看赋予scott用户的对象权限
select *
from dba_tab_privs
where grantee ='XCY';
4.查看授予了scott的角色权限
select t.grantee,t.granted_role, t.admin_option, t.default_role
from dba_role_privs t
where t.grantee = 'SCOTT';
5.查看scott用户使用了哪些表空间
select t.table_name, t.tablespace_name
from dba_all_tables t
where t.owner = 'SCOTT' ;
6.查看当前用户拥有的权限
select t.privilege
from session_privs t
7.查看角色(resource)权限的系统权限
select *
from role_sys_privs t1
where t1.role = 'RESOURCE'
8.查看角色(DBA)被赋予的角色权限
select *
from role_role_privs t
where t.role = 'DBA'
9.查看角色(DBA)被赋予的对象权限
select *
from role_tab_privs t1
where t1.role = 'DBA'