ROLE_SYS_PRIVS_ALL

Previous Next JavaScript must be enabled to correctly display this content

7.256 ROLE_SYS_PRIVS_ALL

ROLE_SYS_PRIVS_ALL describes system privileges and schema privileges granted to roles.

Information is provided only about roles to which the user has access.

Column	Datatype	NULL	Description
`ROLE`	`VARCHAR2(128)`		Name of the role
`PRIVILEGE`	`VARCHAR2(40)`		Privilege granted to the role
`SCHEMA`	`VARCHAR2(128)`		Schema on which the privilege was granted For system privileges, the value of this column is null.
`ADMIN_OPTION`	`VARCHAR2(3)`		Indicates whether the grant was with the `ADMIN` option (`YES`) or not (`NO`)
`COMMON`	`VARCHAR2(3)`		Indicates how the grant was made. Possible values: `YES` if the privilege was granted commonly (`CONTAINER=ALL` was used) `NO` if the privilege was granted locally (`CONTAINER=ALL` was not used)
`INHERITED`	`VARCHAR2(3)`		Indicates whether the role grant was inherited from another container (`YES`) or not (`NO`)

Note:

This view is available starting with Oracle Database 23ai.