I am trying to GRANT a user INSERT access to just one table in the database. The demo is the database.
Following screenshot shows the schema privilege,
With this, user get following error.
Error Code: 1142. INSERT command denied to user 'user4'@'localhost' for table 'student_info'.
If I GRANT the user INSERT access at the database “demo” level, the insert works fine but that GRANT will give the user INSERT rights to all the tables in demo database.
How can I give INSERT access to just one table?
Thanks