User role for linked server

• sanuj

  SSC-Addicted

  Points: 438

  More actions

  December 15, 2008 at 6:51 am

  #126529

  I want to add a user to a role. He should not have any other rights of sysadmin.

  But should be able to use linked server, ie. to use sp_addlinkedserver to add another server .

  How it can be done ?

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  December 15, 2008 at 8:07 am

  #912473

  From BOL entry on sp_addlinkedserver:

  Permissions

  Requires ALTER ANY LINKED SERVER permission.

  Grant ALTER ANY LINKED SERVER to login_name

  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