Grant Update Permission

[shersu]

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

[brucevde]

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.

[shersu]

I'm using SQL Server 2008 Express.

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

Thanks