columns_priv

The m_schema.columns_priv view displays information about GaussDB users' permissions on columns.

**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. Not supported. It is always null.

If the value of sql_mode contains ansi_quotes, add double quotation marks when querying the user column. For example:
```
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. For example:
```
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.