USER_ROLE

6.574 USER_ROLE_PRIVS

USER_ROLE_PRIVS describes the roles granted to the current user.

Column	Datatype	Description
`USERNAME`	`VARCHAR2(128)`	Name of the user, or `PUBLIC`
`GRANTED_ROLE`	`VARCHAR2(128)`	Name of the role granted to the user
`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`)
`OS_GRANTED`	`VARCHAR2(3)`	Indicates whether the role was granted by the operating system (`YES`) or not (`NO`); occurs if the `OS_ROLES` initialization parameter is `true`
`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 grant was inherited from another container (`YES`) or not (`NO`) This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).