Permissions down to a column object level

[Sandi]

Is there a way in SQL Server to give only certain users the access to modify a column in table?

 

[foxdev]

You can use the GRANT statement to specify permissions down to the column level. See GRANT in BOL for an exhaustive description.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[Sandi]

Actually, I ended up using 'DENY UPDATE ON tablename(columnname) TO user' and this worked to deny access to modify one column in a table to a user.

Thanks for your help.