Documentation Home
MySQL 9.3 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 261.1Kb
Man Pages (Zip) - 368.3Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.3 Reference Manual  / ...  / INFORMATION_SCHEMA Tables  / INFORMATION_SCHEMA General Tables  /  The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table

28.3.10 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table

TheCOLUMN_PRIVILEGES table provides information about column privileges. It takes its values from themysql.columns_priv system table.

TheCOLUMN_PRIVILEGES table has these columns:

  • GRANTEE

    The name of the account to which the privilege is granted, in'user_name'@'host_name' format.

  • TABLE_CATALOG

    The name of the catalog to which the table containing the column belongs. This value is alwaysdef.

  • TABLE_SCHEMA

    The name of the schema (database) to which the table containing the column belongs.

  • TABLE_NAME

    The name of the table containing the column.

  • COLUMN_NAME

    The name of the column.

  • PRIVILEGE_TYPE

    The privilege granted. The value can be any privilege that can be granted at the column level; seeSection 15.7.1.6, “GRANT Statement”. Each row lists a single privilege, so there is one row per column privilege held by the grantee.

    In the output fromSHOW FULL COLUMNS, the privileges are all in one column and in lowercase, for example,select,insert,update,references. InCOLUMN_PRIVILEGES, there is one privilege per row, in uppercase.

  • IS_GRANTABLE

    YES if the user has theGRANT OPTION privilege,NO otherwise. The output does not listGRANT OPTION as a separate row withPRIVILEGE_TYPE='GRANT OPTION'.

Notes

The following statements arenot equivalent:

SELECT ... FROM INFORMATION_SCHEMA.COLUMN_PRIVILEGESSHOW GRANTS ...