mysql 只给更新表的某个字段的授权

	
	mysql> create view v_Procuct  as select sn,name from Product;
Query OK, 0 rows affected (0.01 sec)

mysql>  GRANT UPDATE ON `zjzc`.`v_Procuct` TO 'zjzc_limit_cn'@'%' ;
Query OK, 0 rows affected (0.00 sec)
	
	mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
	

posted @ 2016-02-25 10:49  czcb  阅读(139)  评论(0编辑  收藏  举报