DBA_ROLES

DBA_ROLES lists all roles that exist in the database.

Column	Datatype	NULL	Description
`ROLE`	`VARCHAR2(30)`	`NOT NULL`	Role name
`PASSWORD_REQUIRED`	`VARCHAR2(8)`		Indicates if the role requires a password to be enabled