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
`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`)
`IMPLICIT`	`VARCHAR2(3)`		Indicates whether the role is a common role created by an implicit application (`YES`) or not (`NO`)
`EXTERNAL_NAME`	`VARCHAR2(4000)`		For a global role, the external name refers to the DN of a group from a directory service that is mapped to the global role. This is not applicable to a local role.