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
ROLE_TABLE_GRANTS table has these columns:
The user name part of the account that granted the role.
The host name part of the account that granted the role.
The user name part of the account to which the role is granted.
The host name part of the account to which the role is granted.
The name of the catalog to which the role applies. This value is always
The name of the schema (database) to which the role applies.
The name of the table to which the role applies.
The privilege granted. The value can be any privilege that can be granted at the table level; see Section 220.127.116.11, “GRANT Syntax”. Each row lists a single privilege, so there is one row per column privilege held by the grantee.
NO, depending on whether the role is grantable to other accounts.