MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
The ROLE_TABLE_GRANTS table
(available as of MySQL 8.0.19) 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.