MySQL 8.4 Release Notes
28.3.28 INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS 表
The ROLE_ROUTINE_GRANTS table provides information about the routine privileges for roles that are available to or granted by the currently enabled roles.
The ROLE_ROUTINE_GRANTS table has these columns:
-
GRANTORThe user name part of the account that granted the role.
-
GRANTOR_HOSTThe host name part of the account that granted the role.
-
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.
-
SPECIFIC_CATALOGThe name of the catalog to which the routine belongs. This value is always
def. -
SPECIFIC_SCHEMAThe name of the schema (database) to which the routine belongs.
-
SPECIFIC_NAMEThe name of the routine.
-
ROUTINE_CATALOGThe name of the catalog to which the routine belongs. This value is always
def. -
ROUTINE_SCHEMAThe name of the schema (database) to which the routine belongs.
-
ROUTINE_NAMEThe name of the routine.
-
PRIVILEGE_TYPEThe privilege granted. The value can be any privilege that can be granted at the routine level; see Section 15.7.1.6, “GRANT Statement”. Each row lists a single privilege, so there is one row per column privilege held by the grantee.
-
IS_GRANTABLEYESorNO, depending on whether the role is grantable to other accounts.