title: how to grant privileges to all columns except one?
body: <p>I want to grant user an <code>update</code> privilege to update all columns except one - Id in my case (changing Id could make a mess in data, existing URLs etc. - foreign keys are <em>not</em> a solution). Is it possible in mysql without listing all the other columns? E.g. somehow by saying:</p>
  
  <pre><code>grant update on db.table to user;
  NOT grant update id on db.table to user;
  </code></pre>
  
  <p>or something like that?</p>
  
  <p>Reasons why I don't want to list all the columns:</p>
  
  <ol>
  <li><p>it is more robust - I often add some columns to tables later and I would probably forget that I must also update this rule,</p></li>
  <li><p>I don't have the <code>grant</code> permission so I must ask my hosting provider to run every <code>grant</code> command, so I want to minimize these requests as it is an above-standard service (it's their grace to me).</p></li>
  </ol>
  
  <p>Particularly for mysql, but I'm also interested in gereric sql solution.</p>