To Show Role & Privileges For Certain Oracle Database User
SQL> SELECT grantee, privilege FROM dba_sys_privs WHERE grantee = 'DBA'
2 ORDER BY privilege;
GRANTEE PRIVILEGE
------------------ ----------------------------------------
DBA ADMINISTER ANY SQL TUNING SET
DBA ADMINISTER DATABASE TRIGGER
DBA ADMINISTER RESOURCE MANAGER
DBA ADMINISTER SQL TUNING SET
DBA ADVISOR
DBA ALTER ANY CLUSTER
DBA ALTER ANY DIMENSION
DBA ALTER ANY EVALUATION CONTEXT
DBA ALTER ANY INDEX
DBA ALTER ANY INDEXTYPE
DBA ALTER ANY LIBRARY
DBA ALTER ANY MATERIALIZED VIEW
DBA ALTER ANY OUTLINE
DBA ALTER ANY PROCEDURE
DBA ALTER ANY ROLE
DBA ALTER ANY RULE
DBA ALTER ANY RULE SET
DBA ALTER ANY SEQUENCE
DBA ALTER ANY SQL PROFILE
DBA ALTER ANY TABLE
DBA ALTER ANY TRIGGER
DBA ALTER ANY TYPE
DBA ALTER DATABASE
DBA ALTER PROFILE
DBA ALTER RESOURCE COST
DBA ALTER ROLLBACK SEGMENT
DBA ALTER SESSION
DBA ALTER SYSTEM
DBA ALTER TABLESPACE
DBA ALTER USER
DBA ANALYZE ANY
DBA ANALYZE ANY DICTIONARY
DBA AUDIT ANY
DBA AUDIT SYSTEM
DBA BACKUP ANY TABLE
DBA BECOME USER
DBA CHANGE NOTIFICATION
DBA COMMENT ANY TABLE
DBA CREATE ANY CLUSTER
DBA CREATE ANY CONTEXT
DBA CREATE ANY DIMENSION
DBA CREATE ANY DIRECTORY
DBA CREATE ANY EVALUATION CONTEXT
DBA CREATE ANY INDEX
DBA CREATE ANY INDEXTYPE
DBA CREATE ANY JOB
DBA CREATE ANY LIBRARY
DBA CREATE ANY MATERIALIZED VIEW
DBA CREATE ANY OPERATOR
DBA CREATE ANY OUTLINE
DBA CREATE ANY PROCEDURE
DBA CREATE ANY RULE
DBA CREATE ANY RULE SET
DBA CREATE ANY SEQUENCE
DBA CREATE ANY SQL PROFILE
DBA CREATE ANY SYNONYM
DBA CREATE ANY TABLE
DBA CREATE ANY TRIGGER
DBA CREATE ANY TYPE
DBA CREATE ANY VIEW
DBA CREATE CLUSTER
DBA CREATE DATABASE LINK
DBA CREATE DIMENSION
DBA CREATE EVALUATION CONTEXT
DBA CREATE EXTERNAL JOB
DBA CREATE INDEXTYPE
DBA CREATE JOB
DBA CREATE LIBRARY
DBA CREATE MATERIALIZED VIEW
DBA CREATE OPERATOR
DBA CREATE PROCEDURE
DBA CREATE PROFILE
DBA CREATE PUBLIC DATABASE LINK
DBA CREATE PUBLIC SYNONYM
DBA CREATE ROLE
DBA CREATE ROLLBACK SEGMENT
DBA CREATE RULE
DBA CREATE RULE SET
DBA CREATE SEQUENCE
DBA CREATE SESSION
DBA CREATE SYNONYM
DBA CREATE TABLE
DBA CREATE TABLESPACE
DBA CREATE TRIGGER
DBA CREATE TYPE
DBA CREATE USER
DBA CREATE VIEW
DBA DEBUG ANY PROCEDURE
DBA DEBUG CONNECT SESSION
DBA DELETE ANY TABLE
DBA DEQUEUE ANY QUEUE
DBA DROP ANY CLUSTER
DBA DROP ANY CONTEXT
DBA DROP ANY DIMENSION
DBA DROP ANY DIRECTORY
DBA DROP ANY EVALUATION CONTEXT
DBA DROP ANY INDEX
DBA DROP ANY INDEXTYPE
DBA DROP ANY LIBRARY
DBA DROP ANY MATERIALIZED VIEW
DBA DROP ANY OPERATOR
DBA DROP ANY OUTLINE
DBA DROP ANY PROCEDURE
DBA DROP ANY ROLE
DBA DROP ANY RULE
DBA DROP ANY RULE SET
DBA DROP ANY SEQUENCE
DBA DROP ANY SQL PROFILE
DBA DROP ANY SYNONYM
DBA DROP ANY TABLE
DBA DROP ANY TRIGGER
DBA DROP ANY TYPE
DBA DROP ANY VIEW
DBA DROP PROFILE
DBA DROP PUBLIC DATABASE LINK
DBA DROP PUBLIC SYNONYM
DBA DROP ROLLBACK SEGMENT
DBA DROP TABLESPACE
DBA DROP USER
DBA ENQUEUE ANY QUEUE
DBA EXECUTE ANY CLASS
DBA EXECUTE ANY EVALUATION CONTEXT
DBA EXECUTE ANY INDEXTYPE
DBA EXECUTE ANY LIBRARY
DBA EXECUTE ANY OPERATOR
DBA EXECUTE ANY PROCEDURE
DBA EXECUTE ANY PROGRAM
DBA EXECUTE ANY RULE
DBA EXECUTE ANY RULE SET
DBA EXECUTE ANY TYPE
DBA EXPORT FULL DATABASE
DBA FLASHBACK ANY TABLE
DBA FORCE ANY TRANSACTION
DBA FORCE TRANSACTION
DBA GLOBAL QUERY REWRITE
DBA GRANT ANY OBJECT PRIVILEGE
DBA GRANT ANY PRIVILEGE
DBA GRANT ANY ROLE
DBA IMPORT FULL DATABASE
DBA INSERT ANY TABLE
DBA LOCK ANY TABLE
DBA MANAGE ANY FILE GROUP
DBA MANAGE ANY QUEUE
DBA MANAGE FILE GROUP
DBA MANAGE SCHEDULER
DBA MANAGE TABLESPACE
DBA MERGE ANY VIEW
DBA ON COMMIT REFRESH
DBA QUERY REWRITE
DBA READ ANY FILE GROUP
DBA RESTRICTED SESSION
DBA RESUMABLE
DBA SELECT ANY DICTIONARY
DBA SELECT ANY SEQUENCE
DBA SELECT ANY TABLE
DBA SELECT ANY TRANSACTION
DBA UNDER ANY TABLE
DBA UNDER ANY TYPE
DBA UNDER ANY VIEW
DBA UPDATE ANY TABLE
160 rows selected.
SQL>
