Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-08 : 23:01:27
|
Chris writes "How can I find a unique identifier to store in my SQL (Access) table for use in user authentication that is not IP Address?
I have been using IP Address until I found that my company's network works such that when you are using varIP = Request.ServerVariables ("REMOTE_ADDR") the same IP Address is being registered for any user's computer. This won't work because I have a "Security" level in the user's record which limits his/her access to various ASP pages and when I use:
SQL = "SELECT * FROM tUsers WHERE tUsers.UserIP = '" & LOGIP & "';"
I will have mutltiple records in the collection instead of just one.
I do not want to use session variables for various reasons. I just want one surefire unique identifier that will be stored in the authentication table when user successfully logs in.
I am now trying Session.SessionID instead of Request.ServerVariables ("REMOTE_ADDR") and this works, but I am not sure this is the best idea.
Any help would be appreciated.
Thanks,
Chris Broadbent" |
|
|
|
|
|
SQL based authentication not using IP address