Grant Update Permission

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

Which database? Which version?

For SQL Server 2000/7.0

You can supply a list of columns to the Grant statement.

Grant Update (List of Columns) On TableName To User

User's will also need Select permissions in order to use a Where clause in their Update statements.

For SQL Server 2005/2008, you can still use the Grant statement but the syntax is a little different.

You can also use the SQL Server Management Studio to set Column specific permissions for a user.

I'm using SQL Server 2008 Express.

This user is one among the BUILTIN\Users. So how do I go about it?

Thanks