The INFORMATION_SCHEMA COLUMN_STATISTICS Table In the output from  SHOW FULL COLUMNS , the privileges are all in one column and in lowercase, for example,  select,insert,update,references . In  COLUMN_PRIVILEGES , there is one privilege per row, in uppercase. YES  if the user has the  GRANT OPTION  privilege,  NO  otherwise. The output does not list  GRANT OPTION as a separate row with  PRIVILEGE_TYPE=’GRANT OPTION’ . The following statements are  not  equivalent: The  COLUMN_STATISTICS  table provides access to histogram statistics for column values. For information about histogram statistics, see Section 8.9.6, “Optimizer Statistics” , and Section 13.7.3.1, “ANALYZE TABLE Statement” . You can see information only for columns for which you have some privilege. The  COLUMN_STATISTICS  table has these columns: The  ENABLED_ROLES  table (available as of MySQL 8.0.19) provides information about the roles that are enabled within the current session. The  ENABLED_ROLES  table has these columns: • IS_GRANTABLE • COLUMN_PRIVILEGES  is a nonstandard  INFORMATION_SCHEMA  table. A  JSON  object describing the column statistics, stored as a histogram. The names of the column for which the statistics apply. The names of the column for which the statistics apply. The names of the schema for which the statistics apply. • SCHEMA_NAME • TABLE_NAME • COLUMN_NAME • HISTOGRAM • ROLE_NAME • ROLE_HOST The user name part of the granted role. 26.3.12 The INFORMATION_SCHEMA ENABLED_ROLES Table 26.3.11 The INFORMATION_SCHEMA COLUMN_STATISTICS Table Notes SELECT ... FROM INFORMATION_SCHEMA.COLUMN_PRIVILEGES SHOW GRANTS ... 4786