MySQL 8.4 Release Notes
28.3.2 INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS 表
The ADMINISTRABLE_ROLE_AUTHORIZATIONS table provides information about which roles applicable for the current user or role can be granted to other users or roles.
The ADMINISTRABLE_ROLE_AUTHORIZATIONS 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.