All Roles which exist in the database
Columns
___________________________
ROLE
Role Name
PASSWORD_REQUIRED
Indicates if the role requires a password to be enabled
Related:
DBA_APPLICATION_ROLES
DBA_CONNECT_ROLE_GRANTEES
DBA_ROLE_PRIVS