has some short database examples
And here's the basic concept of a login page:
Classic ASP Design Tips - Login Page
Session("UserName") = objRS("UserName")
Session("UserLevel") = objRS("UserLevel")
Then you can use If Then's or Select Case on each page to control whether a user is allowed to actually be there and whether particular links of where a user can go actually show up.
If (Session("UserLevel") <> "Admin") And (Session("UserLevel") <> "Regular") Then