Static Data Dictionary Views, 311 of 452

ROLE_SYS_PRIVS

ROLE_SYS_PRIVS contains information about 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)

Signifies the grant was with the ADMIN option

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)`		Signifies the grant was with the `ADMIN` option