MySQL Tutorial/Privilege/columns priv

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

column privilege

   <source lang="sql">

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)</source>