DBA_ROLES

All Roles which exist in the database

Columns
   ___________________________
 
   ROLE
      Role Name
   PASSWORD_REQUIRED
      Indicates if the role requires a password to be enabled

Related: