MySQL Tutorial/Privilege/columns priv
Версия от 13:44, 26 мая 2010; (обсуждение)
column privilege
mysql>
mysql> desc mysql.columns_priv;
+-------------+----------------------------------------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------------------------------------------+------+-----+-------------------+-------+
| Host | char(60) | NO | PRI | | |
| Db | char(64) | NO | PRI | | |
| User | char(16) | NO | PRI | | |
| Table_name | char(64) | NO | PRI | | |
| Column_name | char(64) | NO | PRI | | |
| Timestamp | timestamp | NO | | CURRENT_TIMESTAMP | |
| Column_priv | set("Select","Insert","Update","References") | NO | | | |
+-------------+----------------------------------------------+------+-----+-------------------+-------+
7 rows in set (0.03 sec)