I'm doing a work and I came up with a possibility that I would like to know if it's possible to do it: the purpose of this idea is to switch a certain connection string
as the logged-in user. That is, I will have a connection string
, which will contain the user information so that it logs in, and in the database of this connection string
I will have the information of another database that this user should connect to. That is, each user group will have a different database to connect to and from the database information that the user must connect to, I would mount the connection string
to it.
Is it possible to implement something like this or is there a better solution?