create user without login - more than one db by app

• paulaalkz 9229

  Old Hand

  Points: 334

  More actions

  March 12, 2014 at 7:08 am

  #290758

  Hello

  I am looking into creating a user without login to be used by the application however the app uses more than one db. Is it still viable? How can the one application access 2 databases using the one user without login?

  1- create db user without login on DB1

  2 - GRANT IMPERSONATE ON USER to a Domain account user

  3 - create db user without login on DB2 ?

  4 - GRANT IMPERSONATE ON USER to the same Domain account user used in step 2?

  Suggestions?

  Thanks!

• Erland Sommarskog

  SSC-Insane

  Points: 24038

  More actions

  March 12, 2014 at 4:25 pm

  #1696569

  This thread is also going on at

  http://social.Msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/34454614-93b9-4d22-842d-cccf25f46849#34454614-93b9-4d22-842d-cccf25f46849

  [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]