MySQL 8.0 Reference Manual
MySQL 8.0 Release Notes
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
orNO
, depending on whether the role is a default role.IS_MANDATORY
YES
orNO
, depending on whether the role is mandatory.