DBA_ROLES v16

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.