REVOKE insert/update/delete privileges to lock a table from modification

[Jayanth Dungavath]

Hello Experts,

I am a software developer and we are going through a major rails application upgrade during which we are locking the entire application to make it read-only. We have done everything except if a user tries to update his profile information, it is getting updated in the MySQL database users table but not in other parts of our application. As I started looking for ways to make a table read-only, I stumbled upon this.

https://stackoverflow.com/questions/3861564/make-a-single-table-in-mysql-read-only

But, it didn't work in my case. Instead, I tried this.

https://github.com/uclibs/scholar_uc/wiki/Make-'users'-table-read-only

Application uses 'jay'@'localhost' user to access database and is the only other user apart from 'root'. When I login to my application and update my profile on the site, it goes through just fine and the users table gets updated even after making the user 'jay' to have only SELECT privileges. I have posted a similar question on dba.stackexchange.com and Rick James did try to help me but I still am in the same spot.

https://dba.stackexchange.com/questions/188368/mysql-why-does-update-query-still-run-with-only-select-privileges-on-a-given-t

Let me know if I'm missing something or help me find a way to make 1 table out of 23 to be read-only during our migration.

Thanks,
Jay