MySQL Partial Revokes Privileges
Percona
SEPTEMBER 7, 2023
Have you ever encountered situations where you want to grant a user access to all databases except a few? Or have you ever tried to revoke partial privileges from a user and you have gotten the below error message? If yes, then this article may interest you. ERROR 1141 (42000): There is no such grant defined for user username on host '%'; Recently, one of our clients requested to REVOKE partial privileges for a single database from a user having ALL the privileges for all the databases, meaning
90 
Let's personalize your content