usage权限能回收的吗
mysql> show grants for 'hxldev'@'%';
+-------------------------------------------------------------------------------------------------------+
| Grants for hxldev@% |
+-------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'hxldev'@'%' IDENTIFIED BY PASSWORD '*E74858DB86EBA20BC33D0AECAE8A8108C56B17FA' |
| GRANT USAGE ON `db_test02`.`db_test.*` TO 'hxldev'@'%' WITH GRANT OPTION
请问下usage权限不能回收的吗,我执行了如下,发现不能回收.
revoke USAGE ON `db_test02`.`db_test.*` from 'hxldev'@'%'
可以,你 drop user 就好了。如果一个用户没有 usage 权限,那可真是生不如死啊。
页:
[1]