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