DBA_ROLES

5.282 DBA_ROLES

DBA_ROLES describes all roles in the database.

Column	Datatype	NULL	Description
`ROLE`	`VARCHAR2(128)`	`NOT NULL`	Name of the role
`ROLE_ID`	`NUMBER`	`NOT NULL`	ID number of the role This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).
`PASSWORD_REQUIRED`	`VARCHAR2(8)`		This column is deprecated in favor of the `AUTHENTICATION_TYPE` column
`AUTHENTICATION_TYPE`	`VARCHAR2(11)`		Indicates the authentication mechanism for the role: `NONE` - `CREATE ROLE` `role1;` `EXTERNAL` - `CREATE ROLE` `role2` `IDENTIFIED EXTERNALLY;` `GLOBAL` - `CREATE ROLE` `role3` `IDENTIFIED GLOBALLY;` `APPLICATION` - `CREATE ROLE` `role4` `IDENTIFIED USING` `schema.package;` `PASSWORD` - `CREATE ROLE` `role5` `IDENTIFIED BY` `role5;`
`COMMON`	`VARCHAR2(3)`		Indicates whether a given role is common. Possible values: `YES` if the role is common `NO` if the role is local (not common)
`ORACLE_MAINTAINED`	`VARCHAR2(1)`		Denotes whether the role was created, and is maintained, by Oracle-supplied scripts (such as catalog.sql or catproc.sql). A role for which this column has the value `Y` must not be changed in any way except by running an Oracle-supplied script.
`INHERITED`	`VARCHAR2(3)`		Indicates whether the role was inherited from another container (`YES`) or not (`NO`) This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).
`IMPLICIT`	`VARCHAR2(3)`		Indicates whether the role is a common role created by an implicit application (`YES`) or not (`NO`) This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).