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.