MySQL 9.3 Reference Manual Including MySQL NDB Cluster 9.3
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:
GRANTOR
The user name part of the account that granted the role.
GRANTOR_HOST
The host name part of the account that granted the role.
GRANTEE
The user name part of the account to which the role is granted.
GRANTEE_HOST
The host name part of the account to which the role is granted.
TABLE_CATALOG
The name of the catalog to which the role applies. This value
is always def.
TABLE_SCHEMA
The name of the schema (database) to which the role applies.
TABLE_NAME
The name of the table to which the role applies.
PRIVILEGE_TYPE
The 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_GRANTABLE
YES or NO, depending on
whether the role is grantable to other accounts.