Table Column Permission

• rew-370421

  Hall of Fame

  Points: 3640

  More actions

  December 29, 2009 at 10:31 am

  #98433

  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?

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  December 30, 2009 at 8:06 am

  #1097456

  The command looks right to me.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question