用户权限

--查看权限
select privilege from dba_sys_privs where grantee='SELECT01';

--查看角色
select granted_role from dba_role_privs where grantee='SELECT01';

--查看用户的所有权限包含其角色的权限
select privilege from dba_sys_privs where grantee='SELECT01' union 
select privilege from dba_sys_privs where grantee in (select granted_role from dba_role_privs where grantee='SELECT01' );