> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-procs_priv-table.md).

# mysql.procs\_priv Table

1. PARTITION BY SYSTEM\_TIME is not supported for transaction-precise system-versioned tables. Attempting

The `mysql.procs_priv` table contains information about [stored procedure](/docs/server/server-usage/stored-routines/stored-procedures.md) and [stored function](/docs/server/server-usage/stored-routines/stored-functions.md) privileges. See [CREATE PROCEDURE](/docs/server/server-usage/stored-routines/stored-procedures/create-procedure.md) and [CREATE FUNCTION](/docs/server/reference/sql-statements/data-definition/create/create-function.md) on creating these.

The [INFORMATION\_SCHEMA.ROUTINES](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-routines-table.md) table derives its contents from `mysql.procs_priv`.

This table uses the [Aria](/docs/server/server-usage/storage-engines/aria.md) storage engine.

The `mysql.procs_priv` table contains the following fields:

| Field         | Type                                                    | Null | Key | Default            | Description                                                                                                                                                                                                                                                                                                                                                                                      |
| ------------- | ------------------------------------------------------- | ---- | --- | ------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| Host          | char(60)                                                | NO   | PRI |                    | Host (together with Db, User, Routine\_name and Routine\_type makes up the unique identifier for this record).                                                                                                                                                                                                                                                                                   |
| Db            | char(64)                                                | NO   | PRI |                    | Database (together with Host, User, Routine\_name and Routine\_type makes up the unique identifier for this record).                                                                                                                                                                                                                                                                             |
| User          | char(80)                                                | NO   | PRI |                    | User (together with Host, Db, Routine\_name and Routine\_type makes up the unique identifier for this record).                                                                                                                                                                                                                                                                                   |
| Routine\_name | char(64)                                                | NO   | PRI |                    | Routine\_name (together with Host, Db User and Routine\_type makes up the unique identifier for this record).                                                                                                                                                                                                                                                                                    |
| Routine\_type | enum('FUNCTION','PROCEDURE', 'PACKAGE', 'PACKAGE BODY') | NO   | PRI | NULL               | Whether the routine is a [stored procedure](/docs/server/server-usage/stored-routines/stored-procedures.md), [stored function](/docs/server/server-usage/stored-routines/stored-functions.md), [package](/docs/server/reference/sql-statements/data-definition/create/create-package.md) or [package body](/docs/server/reference/sql-statements/data-definition/create/create-package-body.md). |
| Grantor       | char(141)                                               | NO   | MUL |                    |                                                                                                                                                                                                                                                                                                                                                                                                  |
| Proc\_priv    | set('Execute','Alter Routine','Grant')                  | NO   |     |                    | The routine privilege. See [Function Privileges](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md#function-privileges) and [Procedure Privileges](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md#procedure-privileges) for details.                                                                                            |
| Timestamp     | timestamp                                               | NO   |     | CURRENT\_TIMESTAMP |                                                                                                                                                                                                                                                                                                                                                                                                  |

The [Acl\_function\_grants](/docs/server/server-management/variables-and-modes/server-status-variables.md#acl_function_grants) status variable indicates how many rows the `mysql.columns_priv` table contains with the `FUNCTION` routine type.

The [Acl\_procedure\_grants](/docs/server/server-management/variables-and-modes/server-status-variables.md#acl_procedure_grants) status variable indicates how many rows the `mysql.columns_priv` table contains with the `PROCEDURE` routine type.

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}