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)