General Roles and System privileges assigned to DBAs in Oracle Projects

General Roles and System privileges assigned to DBA.
--------------------------------------------------------------------------
Roles
=============
GRANTED_ROLE
DATAPUMP_IMP_FULL_DATABASE
SCHEDULER_ADMIN
OLAP_DBA
EXECUTE_CATALOG_ROLE
DELETE_CATALOG_ROLE
OLAP_XS_ADMIN
SELECT_CATALOG_ROLE
EXP_FULL_DATABASE
GATHER_SYSTEM_STATISTICS
JAVA_DEPLOY
DATAPUMP_EXP_FULL_DATABASE
JAVA_ADMIN
XDB_SET_INVOKER
IMP_FULL_DATABASE
XDBADMIN








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


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