Mega Code Archive

 

Categories / MySQL Tutorial / Privilege

 

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)