title: MySQL grant all privileges to database except one table
body: <p>I've been unable to find a reasonable solution to achieve the following:</p>
  
  <p>I wish to have a user that has ALL privileges on a database (or series of databases with the same schema), <strong>except</strong> for one table, to which they will only have SELECT privileges.</p>
  
  <p>Essentially I want the user to have free reign over a database but not to be able to update a specific table.</p>
  
  <p>So far I have tried, to no avail:</p>
  
  <ul>
  <li><p>Granting all privileges on that database (db_name.*) and then specifically granting only select privileges on that desired table (hoping it would overwrite the "all", stupid I know).</p></li>
  <li><p>Granting all privileges on that database (db_name.*) then revoking insert, update, and delete. But this produced an error saying there was no grant rule for db_name.table_name.</p></li>
  </ul>
  
  <p>From what I've been able to gather I'll have to individually grant all privileges on each table of the database except the read only table.</p>
  
  <p><em>Please someone tell me there is a easier way</em></p>
  
  <p><strong>Note</strong>: I'm running MySQL 5.1. The latest available on Ubuntu 10.04.</p>