Dynamic connection string in asp net mvc?

Question

ASP.NET

Hello. There is an application written in asp net mvc, I had to change the database and the new database manager made the separation of roles and information at the database level, i.e. Each user of the system has its own database user. (When a user logs in to the application, his login and password are inserted into the connection string) The question is - how can I store such a connection string in the application? Something in general, ideas are either bad or very bad, completely hopeless. Guess who can do something like this? Or knows how to do it?

Answer 1

You can simply store wildcards like "Server=MyServer;[email protected];[email protected]" and substitute them for each user.
I'm embarrassed that I have to store it in the open. Or you need to encrypt by key and decrypt on the fly.

Answer 2

the baseman made the separation of roles and information at the database level, i.e., each user of the system has its own database user.

Say that you do not accept the work and ask to redo it.