dba、connect、resource角色的权限

• dba角色

SYS@orcl> select role,privilege from role_sys_privs where role='DBA';

ROLE             PRIVILEGE
-------------------- ------------------------------
DBA             CREATE SESSION
DBA             ALTER SESSION
DBA             DROP TABLESPACE
DBA             BECOME USER
DBA             DROP ROLLBACK SEGMENT
DBA             SELECT ANY TABLE
DBA             INSERT ANY TABLE
DBA             UPDATE ANY TABLE
DBA             DROP ANY INDEX
DBA             SELECT ANY SEQUENCE
DBA             CREATE ROLE
DBA             EXECUTE ANY PROCEDURE
DBA             ALTER PROFILE
DBA             CREATE ANY DIRECTORY
DBA             CREATE ANY LIBRARY
DBA             EXECUTE ANY LIBRARY
DBA             ALTER ANY INDEXTYPE
DBA             DROP ANY INDEXTYPE
DBA             DEQUEUE ANY QUEUE
DBA             EXECUTE ANY EVALUATION CONTEXT
DBA             EXPORT FULL DATABASE
DBA             CREATE RULE
DBA             ALTER ANY SQL PROFILE
DBA             ADMINISTER ANY SQL TUNING SET
DBA             CHANGE NOTIFICATION
DBA             DROP ANY EDITION
DBA             DROP ANY MINING MODEL
DBA             ALTER ANY MINING MODEL
DBA             ALTER ANY CUBE DIMENSION
DBA             CREATE CUBE
DBA             DROP ANY CUBE BUILD PROCESS
DBA             ALTER ROLLBACK SEGMENT
DBA             DELETE ANY TABLE
DBA             ALTER DATABASE
DBA             FORCE ANY TRANSACTION
DBA             ALTER ANY PROCEDURE
DBA             DROP ANY TRIGGER
DBA             DROP ANY MATERIALIZED VIEW
DBA             UNDER ANY TYPE
DBA             ALTER ANY LIBRARY
DBA             CREATE DIMENSION
DBA             DEBUG ANY PROCEDURE
DBA             CREATE RULE SET
DBA             ALTER ANY RULE SET
DBA             ANALYZE ANY DICTIONARY
DBA             ALTER ANY EDITION
DBA             CREATE ANY ASSEMBLY
DBA             ALTER ANY CUBE
DBA             SELECT ANY CUBE
DBA             DROP ANY MEASURE FOLDER
DBA             RESTRICTED SESSION
DBA             CREATE TABLESPACE
DBA             ALTER TABLESPACE
DBA             CREATE USER
DBA             ALTER USER
DBA             LOCK ANY TABLE
DBA             CREATE VIEW
DBA             DROP ANY VIEW
DBA             GRANT ANY ROLE
DBA             CREATE TRIGGER
DBA             CREATE TYPE
DBA             EXECUTE ANY OPERATOR
DBA             CREATE ANY DIMENSION
DBA             ALTER ANY DIMENSION
DBA             CREATE ANY OUTLINE
DBA             ADMINISTER DATABASE TRIGGER
DBA             RESUMABLE
DBA             FLASHBACK ANY TABLE
DBA             CREATE ANY RULE SET
DBA             EXECUTE ANY RULE SET
DBA             IMPORT FULL DATABASE
DBA             EXECUTE ANY RULE
DBA             EXECUTE ANY PROGRAM
DBA             CREATE ANY EDITION
DBA             CREATE ASSEMBLY
DBA             ALTER ANY ASSEMBLY
DBA             CREATE CUBE DIMENSION
DBA             CREATE ANY CUBE BUILD PROCESS
DBA             UPDATE ANY CUBE DIMENSION
DBA             CREATE ANY TABLE
DBA             CREATE ANY INDEX
DBA             CREATE ANY SEQUENCE
DBA             ALTER ANY ROLE
DBA             ANALYZE ANY
DBA             DROP ANY LIBRARY
DBA             CREATE ANY OPERATOR
DBA             CREATE INDEXTYPE
DBA             UNDER ANY TABLE
DBA             DROP ANY DIMENSION
DBA             SELECT ANY DICTIONARY
DBA             GRANT ANY OBJECT PRIVILEGE
DBA             CREATE EVALUATION CONTEXT
DBA             CREATE ANY EVALUATION CONTEXT
DBA             DROP ANY EVALUATION CONTEXT
DBA             CREATE ANY RULE
DBA             CREATE JOB
DBA             CREATE ANY JOB
DBA             CREATE MINING MODEL
DBA             INSERT ANY CUBE DIMENSION
DBA             DROP ANY CUBE
DBA             UPDATE ANY CUBE BUILD PROCESS
DBA             ALTER SYSTEM
DBA             AUDIT SYSTEM
DBA             CREATE ROLLBACK SEGMENT
DBA             DROP ANY TABLE
DBA             COMMENT ANY TABLE
DBA             CREATE CLUSTER
DBA             ALTER ANY INDEX
DBA             DROP PUBLIC DATABASE LINK
DBA             CREATE PROFILE
DBA             ALTER ANY MATERIALIZED VIEW
DBA             ALTER ANY TYPE
DBA             DROP ANY TYPE
DBA             UNDER ANY VIEW
DBA             EXECUTE ANY INDEXTYPE
DBA             DROP ANY CONTEXT
DBA             ALTER ANY OUTLINE
DBA             ADMINISTER RESOURCE MANAGER
DBA             MANAGE SCHEDULER
DBA             MANAGE FILE GROUP
DBA             CREATE ANY MINING MODEL
DBA             SELECT ANY MINING MODEL
DBA             CREATE ANY MEASURE FOLDER
DBA             DELETE ANY MEASURE FOLDER
DBA             CREATE TABLE
DBA             BACKUP ANY TABLE
DBA             CREATE ANY CLUSTER
DBA             DROP ANY SYNONYM
DBA             DROP PUBLIC SYNONYM
DBA             CREATE ANY VIEW
DBA             CREATE SEQUENCE
DBA             ALTER ANY SEQUENCE
DBA             FORCE TRANSACTION
DBA             CREATE PROCEDURE
DBA             CREATE ANY PROCEDURE
DBA             ALTER RESOURCE COST
DBA             DROP ANY DIRECTORY
DBA             CREATE ANY TYPE
DBA             ALTER ANY OPERATOR
DBA             CREATE ANY INDEXTYPE
DBA             ENQUEUE ANY QUEUE
DBA             ON COMMIT REFRESH
DBA             DEBUG CONNECT SESSION
DBA             DROP ANY RULE SET
DBA             EXECUTE ANY CLASS
DBA             MANAGE ANY FILE GROUP
DBA             EXECUTE ANY ASSEMBLY
DBA             EXECUTE ASSEMBLY
DBA             COMMENT ANY MINING MODEL
DBA             CREATE ANY CUBE DIMENSION
DBA             DELETE ANY CUBE DIMENSION
DBA             SELECT ANY CUBE DIMENSION
DBA             ALTER ANY TABLE
DBA             DROP ANY CLUSTER
DBA             CREATE SYNONYM
DBA             CREATE PUBLIC SYNONYM
DBA             DROP ANY SEQUENCE
DBA             DROP ANY ROLE
DBA             AUDIT ANY
DBA             DROP ANY PROCEDURE
DBA             CREATE ANY TRIGGER
DBA             ALTER ANY TRIGGER
DBA             DROP PROFILE
DBA             GRANT ANY PRIVILEGE
DBA             CREATE LIBRARY
DBA             CREATE OPERATOR
DBA             DROP ANY OUTLINE
DBA             MERGE ANY VIEW
DBA             ADMINISTER SQL TUNING SET
DBA             UPDATE ANY CUBE
DBA             INSERT ANY MEASURE FOLDER
DBA             ADMINISTER SQL MANAGEMENT OBJE
             CT

DBA             MANAGE TABLESPACE
DBA             DROP USER
DBA             ALTER ANY CLUSTER
DBA             CREATE ANY SYNONYM
DBA             CREATE DATABASE LINK
DBA             CREATE PUBLIC DATABASE LINK
DBA             CREATE MATERIALIZED VIEW
DBA             CREATE ANY MATERIALIZED VIEW
DBA             EXECUTE ANY TYPE
DBA             DROP ANY OPERATOR
DBA             QUERY REWRITE
DBA             GLOBAL QUERY REWRITE
DBA             MANAGE ANY QUEUE
DBA             CREATE ANY CONTEXT
DBA             ALTER ANY EVALUATION CONTEXT
DBA             ALTER ANY RULE
DBA             DROP ANY RULE
DBA             ADVISOR
DBA             SELECT ANY TRANSACTION
DBA             DROP ANY SQL PROFILE
DBA             CREATE ANY SQL PROFILE
DBA             READ ANY FILE GROUP
DBA             CREATE EXTERNAL JOB
DBA             DROP ANY ASSEMBLY
DBA             DROP ANY CUBE DIMENSION
DBA             CREATE ANY CUBE
DBA             CREATE MEASURE FOLDER
DBA             CREATE CUBE BUILD PROCESS
DBA             FLASHBACK ARCHIVE ADMINISTER

201 rows selected.

• connect角色

SYS@orcl> select role,privilege from role_sys_privs where role='CONNECT';

ROLE             PRIVILEGE
-------------------- ------------------------------
CONNECT          CREATE SESSION

• resource角色
  SYS@orcl> select role,privilege from role_sys_privs where role=‘RESOURCE’;

ROLE PRIVILEGE

RESOURCE CREATE SEQUENCE
RESOURCE CREATE TRIGGER
RESOURCE CREATE CLUSTER
RESOURCE CREATE PROCEDURE
RESOURCE CREATE TYPE
RESOURCE CREATE OPERATOR
RESOURCE CREATE TABLE
RESOURCE CREATE INDEXTYPE

8 rows selected.