I have an DLL which is constantly connected to a SQL Server instance. Normal users can use the dll, but they need to give their own usernames & passwords. The dll would still be connected using a pre-defined username and password.
Basically I need a way to check if a username and password has access to the database. Is there a way to do this using a SQL query?
It would of course be possible to add a encrypted "password" column to a database table for users, but I would prefer not having to do that.