DBA_ROLES

DBA_ROLES describes all roles in the database.

Column	Datatype	NULL	Description
`ROLE`	`VARCHAR2(30)`	`NOT NULL`	Name 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;`