columns_priv

The m_schema.columns_priv view displays information about database users' permissions on columns. For details, see Table 1.

**Table 1** m_schema.columns_priv columns
Name	Type	Description
Host	char(60)	Name of the host.
Db	char(64)	Name of the database (schema).
User	char(32)	Name of the user.
Table_name	char(64)	Name of the table.
Column_name	char(64)	Name of the column.
Timestamp	timestamp	Current timestamp. This column is not supported in the current version, and the value is null.

If the value of sql_mode contains ansi_quotes, add double quotation marks when querying the user column.
```
SELECT "user" FROM m_schema.tables_priv WHERE "user" = 'PUBLIC';
```
If the value of sql_mode does not contain ansi_quotes, add backquotes when querying the user column.
```
SELECT `user` FROM m_schema.tables_priv WHERE `user` = 'PUBLIC';
```
In M-compatible databases of the current version, the Column_priv column is not displayed in this view.