shantanuo
shantanuo

Reputation: 32336

All privileges except "super"

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!

Upvotes: 0

Views: 1917

Answers (1)

Pekka
Pekka

Reputation: 449515

would revoking the privilege immediately afterwards not do the trick?

Something like

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

Upvotes: 4

Related Questions