(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.
ROLE_TABLE_GRANTS table has these
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 184.108.40.206, “GRANT Statement”. 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.