MySQL Tutorial/Data Dictionary/procs priv
Версия от 13:44, 26 мая 2010; (обсуждение)
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