MySQL Tutorial/Privilege/columns priv

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

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)