MySQL数据库安全配置(15) Column_priv set('Select','Insert', 'Update','References') +-------------+-----------------------------+------+-----+---------+-------+ 8 rows in set (0.01 sec)
tables_priv表指定表级权限。在这里指定的一个权限适用于一个表的所有列。
mysql> desc columns_priv; +-------------+------------------------+------+-----+---------+-------+ Field Type Null Key Default Extra +-------------+------------------------+------+-----+---------+-------+ Host char(60) binary PRI Db char(64) binary PRI User char(16) binary PRI Table_name char(64) binary PRI