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 |
|
mark617
Starting Member
2 Posts |
 Posted - 2002-04-26 : 19:47:05
|
| HiI was told that there is a way to set up a login to a web based DB & I could based the login/password off of a table where I would store the user name & password. The question I have is how would I do that?Is there a place somewhere where some one has that described?Thanx |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-04-26 : 20:56:09
|
| HiThis has nothing to do with SQL Server users. It also is a fairly broad question, so I will give you a general overview.Basically, you have a users table, this will store a user ID, login and password, and whatever else you want to store for a user.When a user tries to log in, you try to select a user id based on that username / password combination. If you get one ID back, then the user is authenticated and you can let them in, you might want to use a session value or something to store the user id and to remember the fact that they are logged in.If no ID is found, then the user could not be authenticated and you will not let them in to that area of the site.That is a general rundown. To be more specific is a. beyond the realm of SQLTeam. and b. totally dependant on what you are using for your web scripting language.If you are using ASP, go look at www.4guysfromrolla.com for some articles on this sort of thing.Hope that helpsDamian |
 |
|
|
|
|
|
Web based DB & site logins