Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 0 down vote favorite

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?

share|improve this question
Could you edit your question to include some of the statements you use to set permissions (and which user is executing them), and the error message you get when trying to use those permissions? – Jeremy Smyth Jul 31 '12 at 8:10

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.