Home Oracle Commands Oracle Data Dictionary
v$ Performance views

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:


Simon Sheppard
 SS64.com