Grant Select on some columns for specific user
Yes, you give permissions only required users in SQL Server using GRANT like this

GRANT SELECT ON &lt;schema&gt;.&lt;tablename&gt;(&lt;Col1&gt;,&lt;Col2&gt;) TO [Domain\User]

For more info, refer Grant