ROLE_SYS_PRIVS

Oracle 11gR1

ROLE_SYS_PRIVS describes system privileges granted to roles. Information is provided only about roles to which the user has access.

Column	Datatype	NULL	Description
ROLE	VARCHAR2(30)	NOT NULL	Name of the role
PRIVILEGE	VARCHAR2(40)	NOT NULL	System privilege granted to the role
ADMIN_OPTION	VARCHAR2(3)		Indicates whether the grant was with the ADMIN option (YES) or not (NO)

Note:

1. Show what system privileges are granted to a role

select privilege

, admin_option

from role_sys_privs

where role like 'DBA';

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

Oracle data dictionary views

Oracle dynamic performance views