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>