column privilege : Columns_priv : Privilege MySQL TUTORIALS


MySQL TUTORIALS » Privilege » Columns_priv »

 

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   |     |                   |       |
+-------------+----------------------------------------------+------+-----+-------------------+-------+
rows in set (0.03 sec)



Leave a Comment / Note


 
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

MySQL TUTORIALS

 Navioo Privilege
» Columns_priv