procs_priv

The m_schema.procs_priv view displays information about GaussDB users' permissions on stored procedures and functions.

This view is read-only. All users have the read permission on this view, but they can read only the records that they have 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. 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 Routine_type and Proc_priv columns are not displayed in this view.