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?