T-SQL

[Guest]

I want to grant updated privileges to a column only, but I can't get the
syntax right.

grant update columnname on tablename to username

gives me syntax error.
I seem to have a problem in naming my column. Can anyone give me the correct
syntax?

 

[Dave Fancher]

It looks like you're just missing a pair of parens.

SQL Server 7:
GRANT UPDATE (columnName [,...n]) ON tableName TO account [,...n]

SQL Server 2000:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ga-gz_8odw.asp
GRANT UPDATE ON tableName (columnName [, ...n]) TO account [,...n]
or
GRANT UPDATE (columnName [,...n]) ON tableName TO account [,...n] -- For
backwards compatibility

HTH