The DBA_ROLES view provides the information on all roles with the NOLOGIN property (groups).
| Parameter | Type | Description |
|---|---|---|
| role | TEXT | The name of a role with the NOLOGIN property. For example, a group. |
| password_required | TEXT | This parameter is supported for compatibility only. The value is N. |