There Is No Such Grant Error
I followed the instructions here to create a new user.
The only difference was that when giving the user original privileges I gave it to only one database.
Now I’m trying to remove the users access to a single table in that database with the following:
REVOKE ALL PRIVILEGES ON [database name].[table name] FROM ‘[username]’@‘localhost’;
But I keep getting the following error.
ERROR 1147 (42000): There is no such grant defined for user ‘username’ on host 'localhost’ on table 'table_name’
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×