MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
The ENABLED_ROLES table (available as
of MySQL 8.0.19) provides information about the roles that are
enabled within the current session.
The ENABLED_ROLES table has these
columns:
ROLE_NAME
The user name part of the granted role.
ROLE_HOST
The host name part of the granted role.
IS_DEFAULT
YES or NO, depending on
whether the role is a default role.
IS_MANDATORY
YES or NO, depending on
whether the role is mandatory.