MySQL 8.4 Release Notes
28.3.3 INFORMATION_SCHEMA APPLICABLE_ROLES 表
The APPLICABLE_ROLES table provides information about the roles that are applicable for the current user.
The APPLICABLE_ROLES table has these columns:
-
USERThe user name part of the current user account.
-
HOSTThe host name part of the current user account.
-
GRANTEEThe user name part of the account to which the role is granted.
-
GRANTEE_HOSTThe host name part of the account to which the role is granted.
-
ROLE_NAMEThe user name part of the granted role.
-
ROLE_HOSTThe host name part of the granted role.
-
IS_GRANTABLEYESorNO, depending on whether the role is grantable to other accounts. -
IS_DEFAULTYESorNO, depending on whether the role is a default role. -
IS_MANDATORYYESorNO, depending on whether the role is mandatory.