REVOKE insert/update/delete privileges to lock a table from modification
Posted by: Jayanth Dungavath
Date: October 13, 2017 12:30PM

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.

But, it didn't work in my case. Instead, I tried this.'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 and Rick James did try to help me but I still am in the same spot.

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.


Options: ReplyQuote

Written By
REVOKE insert/update/delete privileges to lock a table from modification
October 13, 2017 12:30PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.