Grant Select on some columns for specific user I have a windows group with 20 people and all 20 people in the group were revoked access for some columns in the table. Now I need to add the select permissions for 2 of the users in this windows group. How can I do this?
Can I simply grant select on these columns directly to these 2 users instead of windows group?

Thank you
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