In one database i have lots of tables which should be read-only for user XY and 3 tables which must be read+write (in the same DB).
I set the DB specific privileges to SELECT only, I tried to append table-specific privileges incl. INSERT/UPDATE/DELETE to the specific tables in this DB.
However, mysql does not allow me to write with this user :-(
How to fix?