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’