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>

Leave a Reply