Permissions for linked server?

• chrisph

  Hall of Fame

  Points: 3701

  More actions

  May 3, 2011 at 8:49 am

  #250150

  Hi all,

  How do I grant a domain account user persmissions to be able to access/query a linked server? I want a DB developer to be able to access this linked server, but I have no idea what permissions are required.

  Thanks

• chrisph

  Hall of Fame

  Points: 3701

  More actions

  May 3, 2011 at 10:05 am

  #1319200

  Found the resolution to this.

  - The user needs to have the public role in the master database, explicitly mapped.

  - Run the following command: Grant Execute on sys.xp_prop_oledb_provider to [login];