title: SQL Server permissions per column invisible to users
body: <p>Can I set up permission on certain columns in db and grant to another in a way that's transparent to the users, let say I have a following grant:</p>
  
  <pre><code>GRANT SELECT ON [dbo].[DIM_Table1](Field1 , Field2 , Field4 ) TO [NDMRole] ; 
  -- column Field3 is missing, it's prohibited to select for this user.
  </code></pre>
  
  <p>if the user tries to do:</p>
  
  <pre><code>SELECT * from Dim_Table1 
  </code></pre>
  
  <p>she will get an error saying that <code>Field3</code> is not allowed to be selected. Is there a way to make this field invisible to user or somehow make it so the user doesn't get an error.</p>
  
  <p>I don't want to create additional views for this. The reason I don't want to create views is there are a lot of users of the systems with different permissions and it will be too much effort to maintain this complex mechanism, a solution with permissions will be much easier.</p>