procs_priv

procs_priv : Procs_priv : Data Dictionary MySQL TUTORIALS

MySQL TUTORIALS » 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