Information Schema COLUMN_PRIVILEGES Table
It has the following columns:
|In the format |
|One of |
|Whether the user has the |
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