tables_priv

The m_schema.tables_priv view displays GaussDB users' permissions on tables.

**Table 1** m_schema.tables_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.
Grantor	char(93)	Name of the user who grants the permission.
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 Table_priv and Column_priv columns are not displayed in this view.