DBA_ROLE_PRIVS

Previous Next JavaScript must be enabled to correctly display this content

5.292 DBA_ROLE_PRIVS

DBA_ROLE_PRIVS describes the roles granted to all users and roles in the database.

Related View

USER_ROLE_PRIVS describes the roles granted to the current user.

Column	Datatype	NULL	Description
`GRANTEE`	`VARCHAR2(128)`		Name of the user or role receiving the grant
`GRANTED_ROLE`	`VARCHAR2(128)`		Granted role name
`ADMIN_OPTION`	`VARCHAR2(3)`		Indicates whether the grant was with the `ADMIN OPTION` (`YES`) or not (`NO`)
`DELEGATE_OPTION`	`VARCHAR2(3)`		Indicates whether the grant was with the `DELEGATE OPTION` (`YES`) or not (`NO`)
`DEFAULT_ROLE`	`VARCHAR2(3)`		Indicates whether the role is designated as a `DEFAULT ROLE` for the user (`YES`) or not (`NO`)
`COMMON`	`VARCHAR2(3)`		Indicates how the grant was made. Possible values: `YES` if the role was granted commonly (`CONTAINER=ALL` was used) `NO` if the role 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`)

See Also:

"USER_ROLE_PRIVS"