Click to See Complete Forum and Search --> : Grant Update Permission


shers
May 5th, 2009, 02:05 AM
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

davide++
May 5th, 2009, 12:21 PM
Hi all.
You didn't say what database you're using, but I doubt you can assign grants on the single column of tables. Check if the table is granted for update.

shers
May 6th, 2009, 01:04 AM
I'm using SQL Server 2008 Express.

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

Thanks