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,