DBA_ROLES v12

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

NameTypeDescription
roleTEXTName of a role having the NOLOGIN attribute – i.e., a group.
password_requiredTEXTIncluded for compatibility only; always N.