Originally Posted by Varius

GRANT only the SELECT privilege to the user when you want it to be read-only. When you need to modify data, then use a different user with more privileges, or temporarily grant UPDATE/INSERT/DELETE whatever to your user, do you thing, and remove those once again.