Finally getting back into the swing of things.
I have a new web project that will be used by many different companies. The back-end data is in SQL Server so I need to create a virtualtable.

For security/auditing purposes, I need to have each connection to the server be from the client with the clients login. The logins are mapped to schemas inside SQL Server.

So that would mean that I need to have some way of grabbing the username and password from the web login, and then dynamically adding that to the VT definition.

What would be the best way to accomplish this.