December 29, 2009 at 1:38 pm
Sorry, this is a duplicate of an entry I put in the SQL2000 forum (as it's for a SQL2000 database). I'm hoping to get a little feedback. 🙂
I need to allow a SQL Account "update" permission on ONE column within a Table. Is this the correct statement in GRANTing that access?
GRANT Update (CompanyName) ON CompanyTables TO JohnSmith
Is there anything I'm missing?
December 30, 2009 at 10:32 am
The syntax according to the SQL Books Online is:
GRANT UPDATE ON <TableName>
TO <UserName>
Andrew SQLDBA
December 30, 2009 at 10:40 am
Sorry about that. I just saw the word "column" in your post
Here is the code for specific column(s)
GRANT UPDATE (<ColumnName_1>, <ColumnName_2>, <ColumnName_n>)
ON <TableName>
TO <UserName>
Andrew SQLDBA
December 30, 2009 at 10:46 am
Great. Thanks, Andrew !
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply