Documentation Home
MySQL Information Schema
Related Documentation Download this Excerpt
PDF (US Ltr) - 333.6Kb
PDF (A4) - 338.0Kb
HTML Download (TGZ) - 59.9Kb
HTML Download (Zip) - 122.0Kb


MySQL Information Schema  /  The INFORMATION_SCHEMA ENABLED_ROLES Table

Chapter 11 The INFORMATION_SCHEMA ENABLED_ROLES Table

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.