tables_priv

The m_schema.tables_priv view displays database users' permissions on tables. For details, see Table 1.

**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. 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 Table_priv and Column_priv columns are not displayed in this view.