Click here to Skip to main content
15,867,568 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
Hi everyone,
I'd like to have DB Logins registered for each user and to have custom connection string for each one. The main benefit of this approach is security. For some reasons, our users need to have their DB password, e.g. taking DB backups, ... .
So for example if I want to register a new user I'd do the following:
1. CREATE LOGIN
2. CREATE USER (on my db)
3. GRAND PREMISSION

and for authentication, each user will have his or her own connection string.

Do you have any idea how I can implement this need?

I don't think there is any out-of-box solution and I'm going to write it anyway. Any suggestion? Can I overwrite Identity?

Thanks,
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900