DBA_ROLES v15

The DBA_ROLES view provides information on all roles with the NOLOGIN attribute (groups).

NameTypeDescription
roleTEXTName of a role having the NOLOGIN attribute, that is, a group.
password_requiredTEXTIncluded only for compatibility. Always N.