--查看权限
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' );
