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.

The mysql.procs_priv table contains the following fields:

FieldTypeNullKeyDefaultDescription
Hostchar(60)NOPRIHost (together with Db, User, Routine_name and Routine_type makes up the unique identifier for this record).
Dbchar(64)NOPRIDatabase (together with Host, User, Routine_name and Routine_type makes up the unique identifier for this record).
Userchar(80)NOPRIUser (together with Host, Db, Routine_name and Routine_type makes up the unique identifier for this record).
Routine_namechar(64)NOPRIRoutine_name (together with Host, Db User and Routine_type makes up the unique identifier for this record).
Routine_typeenum('FUNCTION','PROCEDURE')NOPRINULLWhether the routine is a stored procedure or stored function.
Grantorchar(141)NOMUL
Proc_privset('Execute','Alter Routine','Grant')NOThe routine privilege. See Function Privileges and Procedure Privileges for details.
TimestamptimestampNOCURRENT_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.

Comments

Comments loading...