The mysql.procs_priv table records privileges granted to users specifically for executing or altering stored procedures and functions.
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.
This table uses the Aria storage engine.
The mysql.procs_priv table contains the following fields:
The status variable indicates how many rows the mysql.columns_priv table contains with the FUNCTION routine type.
The 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
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 , , or .
Grantor
char(141)
NO
MUL
Proc_priv
set('Execute','Alter Routine','Grant')
NO
The routine privilege. See and for details.
Timestamp
timestamp
NO
CURRENT_TIMESTAMP
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).
System tables should not normally be edited directly. Use the related SQL statements instead.