procs_priv

The m_schema.procs_priv view displays information about database users' permissions on stored procedures and functions. For details, see Table 1. This view is read-only. All users have the read permission on this view. A user can view only the records that the user has the access permission.

**Table 1** m_schema.procs_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.
Routine_name	char(64)	Name of the routine.
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 Routine_type and Proc_priv columns are not displayed in this view.