The INFORMATION_SCHEMA.COLUMN_PRIVILEGES Table : INFORMATION_SCHEMA « Data Dictionary « MySQL Tutorial

1. MySQL Tutorial
2. Data Dictionary
3. INFORMATION_SCHEMA

The COLUMN_PRIVILEGES table provides information about column privileges.

PRIVILEGE_TYPE can contain one (and only one) of these values: SELECT, INSERT, UPDATE, REFERENCES.

This information comes from the mysql.columns_priv grant table.