Connecting to dBs with different userid and pwd

• PriyaBabu

  Mr or Mrs. 500

  Points: 535

  More actions

  September 9, 2003 at 6:21 am

  #81969

  For eg: I have a database a with userid and

  Pwd c and d respectively. I need to write a query in this database which will access a database b with userid and pwd e and f respectively. Both dbs lie on the same server. Could anyone help me out on this as soon as possible.

  Thanks.

• mccork

  SSC-Insane

  Points: 22288

  More actions

  September 9, 2003 at 6:33 am

  #473182

  Why don't you add login c as user c in database b. Give it the same privileges as user e.

  Preferably, in database b, add a new role and grant all necessary database b privileges to that role. Add users c & e as members of that role.

  Cheers,

  - Mark

  
  Cheers,
  - Mark

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  September 9, 2003 at 10:04 am

  #473254

  I'd use roles, transfer the permission to the role and grant to both users.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  http://www.dkranch.net