Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

create user without login - more than one db by app Expand / Collapse
Author
Message
Posted Wednesday, March 12, 2014 7:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 12:12 PM
Points: 10, Visits: 68
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!
Post #1550214
Posted Wednesday, March 12, 2014 4:25 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 3:40 PM
Points: 786, Visits: 690
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


Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1550451
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse