MySQL Tutorial/Data Dictionary/procs priv

procs_priv

   <source lang="sql">

mysql> desc procs_priv; +--------------+----------------------------------------+------+-----+-------------------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+----------------------------------------+------+-----+-------------------+-------+ | Host | char(60) | NO | PRI | | | | Db | char(64) | NO | PRI | | | | User | char(16) | NO | PRI | | | | Routine_name | char(64) | NO | PRI | | | | Routine_type | enum("FUNCTION","PROCEDURE") | NO | PRI | | | | Grantor | char(77) | NO | MUL | | | | Proc_priv | set("Execute","Alter Routine","Grant") | NO | | | | | Timestamp | timestamp | NO | | CURRENT_TIMESTAMP | | +--------------+----------------------------------------+------+-----+-------------------+-------+ 8 rows in set (0.00 sec) mysql> use test Database changed</source>