The mysql.procs_priv table contains information about stored procedure and stored function privileges. See CREATE PROCEDURE and CREATE FUNCTION on creating these.
The INFORMATION_SCHEMA.ROUTINES table derives its contents from mysql.procs_priv.
In MariaDB 10.4 and later, this table uses the Aria storage engine.
In MariaDB 10.3 and before, this table uses the MyISAM 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, stored function, or, from MariaDB 10.3.5, a package or package body. |
Grantor |
char(141) |
NO | MUL | ||
Proc_priv |
set('Execute','Alter Routine','Grant') |
NO | The routine privilege. See Function Privileges and Procedure Privileges for details. | ||
Timestamp |
timestamp |
NO | CURRENT_TIMESTAMP |
The Acl_function_grants status variable, added in MariaDB 10.1.4, indicates how many rows the mysql.columns_priv table contains with the FUNCTION routine type.
The Acl_procedure_grants status variable, added in MariaDB 10.1.4, indicates how many rows the mysql.columns_priv table contains with the PROCEDURE routine type.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/mysqlprocs_priv-table/