The COLUMN_PRIVILEGES view contains details about column-level privileges.
| Column | Description |
|---|---|
GRANTEE |
The name of the account that has been granted the privilege, in 'user_name'@'host_name' format. |
TABLE_CATALOG |
The catalog where the table containing the column resides. This value is always def. |
TABLE_SCHEMA |
The schema (database) where the table containing the column resides. |
TABLE_NAME |
The name of the table containing the column. |
COLUMN_NAME |
The name of the column. |
PRIVILEGE_TYPE |
The specific privilege granted. Privileges are listed in uppercase. |
IS_GRANTABLE |
Indicates whether the user has the GRANT OPTION privilege: YES if they do, NO if not. This table doesn’t include a separate row for GRANT OPTION with PRIVILEGE_TYPE='GRANT OPTION'. |
Note
The
COLUMN_PRIVILEGESview is a nonstandardINFORMATION_SCHEMAview.
For more information, see the MySQL documentation: The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table.