ROLE_COLUMN_GRANTS table (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
ROLE_COLUMN_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 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 18.104.22.168, “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.