Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Validate SQL Username and password Expand / Collapse
Author
Message
Posted Tuesday, November 2, 2004 10:23 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 5, 2010 4:04 PM
Points: 32, Visits: 99

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..........




Post #144332
Posted Tuesday, November 2, 2004 10:37 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:35 AM
Points: 33,102, Visits: 15,213
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #144339
Posted Tuesday, November 2, 2004 10:46 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 5, 2010 4:04 PM
Points: 32, Visits: 99
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...


Post #144342
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse