title: SQL Server - Restrict UPDATE to specific columns
body: <p>Good day. I explain my scenario. There are two users (user1 and user2). I have a table (tblTest) in SQL server with 3 columns (f1,f2,f3). What I want to do is the following:</p>
  
  <ol>
  <li><p>Deny <code>UPDATE</code> to column f2 and grant <code>UPDATE</code> to columns f1 and f3 for <code>user1</code>. </p></li>
  <li><p>Grant <code>UPDATE</code> to column f2 and deny <code>UPDATE</code> to columns f1 and f3 for <code>user2</code>.</p></li>
  </ol>
  
  <p>For the moment I'm stuck at step 1).</p>
  
  <p>This is what I did:</p>
  
  <p>In SQL Server I selected <code>tblTest =&gt; Properties =&gt; Permissions</code>, selected user1.</p>
  
  <p>In "Permissions for user1" at the bottom => Update then "Column Permissions" button, checked on Deny for f2 and Grant for f1 and f3.</p>
  
  <p>Then I accessed SQL Server with <code>user1</code>'s credentials and tried to update a row in this table. </p>
  
  <p>Obviously the command failed with this message: </p>
  
  <blockquote>
    <p>The UPDATE permission was denied on the column 'f2' of the object 'tblTest', database 'dbremarksSQL', schema 'dbo'.</p>
  </blockquote>
  
  <p>Everything worked as it should so far. My problem is that also the other columns are not updated. I'd like the update command would update the f1 and f3 columns, at least,  and denying the update just to f2 (leaving as it was).</p>
  
  <p>Is that possible?</p>
  
  <p>Thank you</p>
  
  <p>btw I use SQL Server 2014 Management Studio.</p>