Documentation Home
MySQL Information Schema
Related Documentation Download this Excerpt
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb
HTML Download (TGZ) - 97.6Kb
HTML Download (Zip) - 110.0Kb


MySQL Information Schema  /  INFORMATION_SCHEMA General Tables  /  The INFORMATION_SCHEMA ENABLED_ROLES Table

4.12 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.