开发者

All privileges except "super"

开发者 https://www.devze.com 2023-03-03 06:06 出处:网络
The following statement is working as expected 开发者_开发问答grant all on *.* to \'foo\'@\'10.10.%\' identified by \'bar\';

The following statement is working as expected

开发者_开发问答grant all on *.* to 'foo'@'10.10.%' identified by 'bar';

But I want to grant all privileges except "super" privilege. I wish there was "grant all except super" syntax!


would revoking the privilege immediately afterwards not do the trick?

Something like

revoke super on *.* from 'foo'@'10.10.%';
0

精彩评论

暂无评论...
验证码 换一张
取 消