column privilege : columns_priv « Privilege « MySQL Tutorial





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)










27.1.columns_priv
27.1.1.column privilege