November 2, 2004 at 10:23 am
I am working on an ASP.net page to permit users to log themselves out of the database. We are using standard sql logins for security with a commercial application (cant change that end). I was planning to validate username and password when the user connected to database with the through setting connection string variables. If they connect I will call a stored procedure to delete them from proper tables.
Found out that these logins can not connect directly to the database. They do not work from query analyzer. But I still need to validate their username and password somehow.
Any ideas..........
November 2, 2004 at 10:37 am
Store the user and pwd in a table. Pass them to a stored procedure and return a 1 or 0, true or false, approved, failed, whatever.
November 2, 2004 at 10:46 am
I can't change use of logins. I thought of adding security table but the problem is keeping users and passwords in sync between a new table and existing logins. Could use windows domain security for user to enter login/password, but we would have to keep a new database user list mapped list to windows IDs which is a job also. Was hoping there may be someway in databse...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply