Grant Update Permission

[shers]

Hi,

How do I grant update permission to a user to one column of one table?
When he updates the table, the error is 'The UPDATE permission was denied on the object.'

Please help.

Thanks

 

[InertiaM]

In full SQL Server, the syntax is :-

GRANT INSERT, UPDATE, DELETE ON TEST.dbo.BLAH TO SQLUSERNAME;

 

[shers]

The user is not an individual user. He is one among the BUILTIN\Users. So how do I go about it.

Thanks