Permissions on sys.columns

• Helical Johan

  Ten Centuries

  Points: 1033

  More actions

  November 21, 2009 at 7:35 am

  #212796

  Hi, which permissions a user must have for uses sys.columns?

  Thanks,

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 23, 2009 at 8:09 am

  #1082951

  Check out the permissions section in the BOL entry for sys.columns. BOL is a great resource and can answer most of your questions.

  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

• support.sql

  Default port

  Points: 1444

  More actions

  November 29, 2009 at 9:51 am

  #1085143

  By default the user must have READ-ONLY, you don't modify the permissions on system dictionary objects.

  Regards

  SNM

  Try Free Microsoft SQL Server Data Collector & Performance Monitor.

  http://www.analyticsperformance.com[/url]
  
  @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector