DBA_ROLES

All Roles which exist in the database

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

Related Commands:

Simon Sheppard
SS64.com