Connection string for different users logged in

0

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?

    
asked by anonymous 18.11.2016 / 12:23

1 answer

2

You can use the dynamic connection string approach by changing the data of a generic connection string to the database data that the user should use, the data storage of the connection may be in the initial login database.

The link below has an interesting example of how to use this feature.

link

I hope I have helped.

    
18.11.2016 / 12:30