# 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](https://mariadb.com/docs/server/server-usage/stored-routines/stored-procedures) and [stored function](https://mariadb.com/docs/server/server-usage/stored-routines/stored-functions) privileges. See [CREATE PROCEDURE](https://mariadb.com/docs/server/server-usage/stored-routines/stored-procedures/create-procedure) and [CREATE FUNCTION](https://mariadb.com/docs/server/reference/sql-statements/data-definition/create/create-function) on creating these. The [INFORMATION\_SCHEMA.ROUTINES](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-routines-table) table derives its contents from `mysql.procs_priv`. This table uses the [Aria](https://mariadb.com/docs/server/server-usage/storage-engines/aria) 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](https://mariadb.com/docs/server/server-usage/stored-routines/stored-procedures), [stored function](https://mariadb.com/docs/server/server-usage/stored-routines/stored-functions), [package](https://mariadb.com/docs/server/reference/sql-statements/data-definition/create/create-package) or [package body](https://mariadb.com/docs/server/reference/sql-statements/data-definition/create/create-package-body). | | Grantor | char(141) | NO | MUL | | | | Proc\_priv | set('Execute','Alter Routine','Grant') | NO | | | The routine privilege. See [Function Privileges](https://mariadb.com/docs/server/sql-statements/account-management-sql-statements/grant#function-privileges) and [Procedure Privileges](https://mariadb.com/docs/server/sql-statements/account-management-sql-statements/grant#procedure-privileges) for details. | | Timestamp | timestamp | NO | | CURRENT\_TIMESTAMP | | The [Acl\_function\_grants](https://mariadb.com/docs/server/server-management/variables-and-modes/server-status-variables#acl_function_grants) status variable indicates how many rows the `mysql.columns_priv` table contains with the `FUNCTION` routine type. The [Acl\_procedure\_grants](https://mariadb.com/docs/server/server-management/variables-and-modes/server-status-variables#acl_procedure_grants) status variable indicates how many rows the `mysql.columns_priv` table contains with the `PROCEDURE` routine type. *This page is licensed: CC BY-SA / Gnu FDL* {% @marketo/form formId="4316" %}