MySQL 8.3 Release Notes
The ROLE_TABLE_GRANTS table provides information about the table privileges for roles that are available to or granted by the currently enabled roles.
The ROLE_TABLE_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.
-
TABLE_CATALOGThe name of the catalog to which the role applies. This value is always
def. -
TABLE_SCHEMAThe name of the schema (database) to which the role applies.
-
TABLE_NAMEThe name of the table to which the role applies.
-
PRIVILEGE_TYPEThe privilege granted. The value can be any privilege that can be granted at the table 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.