MySQL Tutorial/Data Dictionary/procs priv

Материал из SQL эксперт
Перейти к: навигация, поиск

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