Mega Code Archive

 
Categories / MySQL Tutorial / Data Dictionary
 

Procs_priv

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