时间：2021-07-01 10:21:17 帮助过：34人阅读
由于权限变更，需要将 z1 的权限变更，收回 INSERT，只能对数据进行 SELECT 操作：
| 1 2 3 4 5 6 7 8 | [mysql@db3 ~]$ mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 21757 to server version: 5.1.9-beta-log Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the buffer. mysql> revoke insert on sakila.* from ‘z1‘@‘localhost‘; Query OK, 0 rows affected (0.00 sec) mysql> exit Bye |
用户 z1 重新登录后执行前面语句：
| 1 2 3 4 5 6 7 8 9 10 | [mysql@db3 ~]$ mysql -uz1 -p123 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 21763 to server version: 5.1.9-beta-log Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the buffer. mysql> insert into emp values(‘bzshen‘,‘2005-04-01‘,3000,‘3‘); ERROR 1046 (3D000): No database selected mysql> use sakila Database changed mysql> insert into emp values(‘bzshen‘,‘2005-04-01‘,3000,‘3‘); ERROR 1142 (42000): INSERT command denied to user ‘z1‘@‘localhost‘ for table ‘emp‘ |
以上例子中的 grant 和 revoke 分别授出和收回了用户 z1 的部分权限，达到了我们的目的。
详解MySQL第三篇—DCL语句
标签：定义 目的 tor ror mon ble 变更 connect show