(available as of MySQL 8.0.19) provides information about the
column privileges for roles that are available to or granted by
the currently enabled roles.
ROLE_COLUMN_GRANTS table has
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 name of the column to which the role applies.
The privilege granted. The value can be any privilege that can be granted at the column 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.