Linked server logins and local database roles

• peak123

  Valued Member

  Points: 53

  More actions

  June 17, 2003 at 5:05 am

  #58508

  Is there any way to map a local database role to a linked server login? Or do I have to map every single user to linked server login who needs to query linked server's tables?

  __

  Lauri

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  June 17, 2003 at 6:50 am

  #461720

  Check sp_addlinkedsrvlogin in BOL. If you use @useSelf = true, then the login that you are using, will try to log into de linked server.