The Information Schema COLUMN_PRIVILEGES table contains column privilege information derived from the mysql.columns_priv grant table.
It has the following columns:
| Column | Description |
|---|---|
GRANTEE |
In the format user_name@host_name. |
TABLE_CATALOG |
Always def. |
TABLE_SCHEMA |
Database name. |
TABLE_NAME |
Table name. |
COLUMN_NAME |
Column name. |
PRIVILEGE_TYPE |
One of SELECT, INSERT, UPDATE or REFERENCES. |
IS_GRANTABLE |
Whether the user has the GRANT OPTION for this privilege. |
Similar information can be accessed with the SHOW FULL COLUMNS and SHOW GRANTS statements. See the GRANT article for more about privileges.
This information is also stored in the columns_priv table, in the mysql system database.
For a description of the privileges that are shown in this table, see column privileges.
In the following example, no column-level privilege has been explicitly assigned:
SELECT * FROM information_schema.COLUMN_PRIVILEGES; Empty set
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-column_privileges-table/