MySQL Tutorial/Data Dictionary/procs priv — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
|
(нет различий)
|
Текущая версия на 09:53, 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