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

Most All DBMS systems that I know of do permission locking on objects, and a table is an object while a field is only a part of what describes that object. So to grant permission on a single field is not normally a possible or viable possibility. Hence, my recommendation to use a stored proceedure if you are using SQL Server, Oracle, or any other high end database and if so I would suggest you go to another forum like dbforums.com or tek-tips.com. If using Alpha, MS Access, DBase, Fox Pro, then you may have to enforce this rule via your code.

Good Luck

I'm using SQL Server Express.

The user is one among the BUILTIN/Users.

Thanks

try grant update to [username] on [tablename]

Vb.net 2005, Teradata, Sql Server 2005, mainframe automation