REVOKE priv_type [(column_list)]...
ON database.table
FROM user [, user]...
REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ...
mysql> REVOKE INSERT ON *.* -> FROM 'testUser'@'localhost'; Query OK, 0 rows affected (0.01 sec) mysql> SHOW GRANTS FOR 'testUser'@'localhost'; +-----------------------------------------------------------------+ | Grants for testUser@localhost | +-----------------------------------------------------------------+ | GRANT SELECT ON *.* TO 'testUser'@'localhost' WITH GRANT OPTION | +-----------------------------------------------------------------+ 1 row in set (0.00 sec)结果显示,删除 testUser 用户的 INSERT 权限成功。
本文链接:http://task.lmcjl.com/news/5141.html