角色 RESOURCE、CONNECT、DBA具有的权限

select grantee,privilege from dba_sys_privs where grantee='RESOURCE' order by privilege;

select grantee,privilege from dba_sys_privs where grantee='CONNECT';

select grantee,privilege from dba_sys_privs where grantee='DBA';

查看某个用户具有的权限

select privilege from dba_sys_privs where grantee='ACCOUNT'

union

select privilege from dba_sys_privs where grantee in (select granted_role from dba_role_privs where grantee='ACCOUNT' );

SQL> select privilege from dba_sys_privs where grantee='ACCOUNT'

2 union

3 select privilege from dba_sys_privs where grantee in (select granted_role from dba_role_privs where grantee='ACCOUNT' );

PRIVILEGE

----------------------------------------

CREATE CLUSTER

CREATE INDEXTYPE

CREATE OPERATOR

CREATE PROCEDURE

CREATE SEQUENCE

CREATE SESSION

CREATE TABLE

CREATE TRIGGER

CREATE TYPE

CREATE VIEW

UNLIMITED TABLESPACE

11 rows selected.

select privilege from dba_sys_privs where grantee='PLATFORM'

union

select privilege from dba_sys_privs where grantee in (select granted_role from dba_role_privs where grantee='PLATFORM' );

SQL> select privilege from dba_sys_privs where grantee='PLATFORM'