Mega Code Archive

 
Categories / MSSQL Tutorial / User Role
 

A GRANT statement that grants SELECT permission to specific columns

GRANT  SELECT ON Bankers (BankerName,BankerAddress1,BankerCity,BankerState,BankerZipCode) TO TomAaron, [Payroll\MarkThomas]