information-schema-enabled-roles-table.md 628 字节
Newer Older
茶陵後's avatar
茶陵後 已提交
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
### 26.3.12 The INFORMATION\_SCHEMA ENABLED\_ROLES Table

[]()

 The [`ENABLED_ROLES`](information-schema-enabled-roles-table.html) table (available as of MySQL 8.0.19) provides information about the roles that are enabled within the current session.

 The [`ENABLED_ROLES`](information-schema-enabled-roles-table.html) 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.