Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default User Authentication

    Hi All:

    I would like to have certain areas of a site that I am developing password
    protected but I am not sure how to go about doing this. I know that I
    definitely do not want to use Session variables (as the client may have
    cookies disabled). So the other option I guess is to have the
    username/password checked against a database. I am not sure how to proceed
    with this, though, as there may be more than 1 page that has to be
    password-protected. Most likely all of the password protected pages will
    reside in the same directory or at least have the same parent directory.
    Any suggestions:

    Keep in mind, that at this stage, the database being used is being created
    in Access

    Thanks in advance


    Terry



    Terry Murray Guest

  2. Similar Questions and Discussions

    1. user authentication weirdness
      On our development machine, running MySQL 5.0.19, I created a database alert_db, and for development purposes created a user called alert_db with a...
    2. User Authentication problems
      hi everyone i am using a php site and i have been trying to implement user authentication by completing the macromedia tutorial "Macromedia -...
    3. XP user authentication
      Folks, Given the following function signature: bool AutheticateUser(string uid, string pwd); Can anyone tell me which .Net class.function API...
    4. SQL User authentication
      Is it possible to authenticate user using a SQL database, containing users and passwords? What I want to achive is: I have as SQL database...
    5. DB User authentication.
      Not a programmin newbie, but a PHP newbie. I'm working off the user authentication and database thing off hotscripts.com. It doesn't work, yet...
  3. #2

    Default Re: User Authentication

    Terry

    Presumably you want the pages protected so that, austensibly, only you can
    access them?

    Create a table in your db with two columns ( 3 if there will be more than
    one authorised user - the third being an ID autonumber). Uname and Pword
    for example. Enter your chosen words for both columns.

    Create an html form with input type text, input type password and a submit
    button. Form action Post. Submit to an ASP that compares your input data
    to your saved data in the db. If both user name and password match, then
    set a session variable to true and redirect to wherever you want to go next,
    an admin menu page perhaps.

    If either user name or password fails to match, set the same session
    variable to false and redirect to, for example, unauthorised.html.

    On each page that you want kept private, at the top, place code like this:

    <% @ LANGUAGE="VBSCRIPT" %>
    <% Option Explicit
    If Not Session("adminOK") OR IsNull(Session("adminOK")) = True Then
    Response.Redirect("unauthorised.html")
    End If
    %>

    This will stop the casually curious, but obviously not the determined
    hacker.

    HTH

    Peter

    "Terry Murray" <tgmurray@rogers.com> wrote in message
    news:kKL0b.206953$4UE.277@news01.bloor.is.net.cabl e.rogers.com...
    > Hi All:
    >
    > I would like to have certain areas of a site that I am developing password
    > protected but I am not sure how to go about doing this. I know that I
    > definitely do not want to use Session variables (as the client may have
    > cookies disabled). So the other option I guess is to have the
    > username/password checked against a database. I am not sure how to
    proceed
    > with this, though, as there may be more than 1 page that has to be
    > password-protected. Most likely all of the password protected pages will
    > reside in the same directory or at least have the same parent directory.
    > Any suggestions:
    >
    > Keep in mind, that at this stage, the database being used is being created
    > in Access
    >
    > Thanks in advance
    >
    >
    > Terry
    >
    >
    >

    Peter James Guest

  4. #3

    Default Re: User Authentication

    An alternative to this I use is a separate sessions DB table, where
    you set a user's ID to active after a successful authentication. That
    way you don't have to use session variables at all. I also assign
    unique session IDs so I'm not passing login names as a querystring.
    This has the added advantage of storing login/logout times depending
    on how you want to implement it.
    >Terry
    >
    >Presumably you want the pages protected so that, austensibly, only you can
    >access them?
    >
    >Create a table in your db with two columns ( 3 if there will be more than
    >one authorised user - the third being an ID autonumber). Uname and Pword
    >for example. Enter your chosen words for both columns.
    >
    >Create an html form with input type text, input type password and a submit
    >button. Form action Post. Submit to an ASP that compares your input data
    >to your saved data in the db. If both user name and password match, then
    >set a session variable to true and redirect to wherever you want to go next,
    >an admin menu page perhaps.
    >
    >If either user name or password fails to match, set the same session
    >variable to false and redirect to, for example, unauthorised.html.
    >
    >On each page that you want kept private, at the top, place code like this:
    >
    ><% @ LANGUAGE="VBSCRIPT" %>
    ><% Option Explicit
    >If Not Session("adminOK") OR IsNull(Session("adminOK")) = True Then
    > Response.Redirect("unauthorised.html")
    >End If
    > %>
    >
    >This will stop the casually curious, but obviously not the determined
    >hacker.
    >
    >HTH
    >
    >Peter
    >
    >"Terry Murray" <tgmurray@rogers.com> wrote in message
    >news:kKL0b.206953$4UE.277@news01.bloor.is.net.cab le.rogers.com...
    >> Hi All:
    >>
    >> I would like to have certain areas of a site that I am developing password
    >> protected but I am not sure how to go about doing this. I know that I
    >> definitely do not want to use Session variables (as the client may have
    >> cookies disabled). So the other option I guess is to have the
    >> username/password checked against a database. I am not sure how to
    >proceed
    >> with this, though, as there may be more than 1 page that has to be
    >> password-protected. Most likely all of the password protected pages will
    >> reside in the same directory or at least have the same parent directory.
    >> Any suggestions:
    >>
    >> Keep in mind, that at this stage, the database being used is being created
    >> in Access
    >>
    >> Thanks in advance
    >>
    >>
    >> Terry
    >>
    >>
    >>
    >
    despondent Guest

  5. #4

    Default Re: User Authentication

    goto [url]www.aspin.com[/url] and do a search for password. You'll find some great stuff
    Joe Guest

  6. #5

    Default Re: User Authentication

    Thanks for the quick response. If I am understanding what you are
    suggesting correctly does that mean that each time a user accesses a page in
    that directory a check is made in the username/password table to see if
    he/she exists? If the user exists then an entry is made into the sessions
    DB table which would generate a session id number (perhaps just an
    autonumber in the database). Then each time a user accesses a page in that
    directory a check is made to see if that session id exists in the sessions
    DB table. Am I correct in assuming than this is how this approach could be
    implemented. Also, perhaps the session id would not be an autonumber in the
    table maybe a random number could be generated.

    Thanks again

    Terry

    "despondent" <the@despondent.net> wrote in message
    news:8oe7kvgocvfn56ef2aam1pfhn27lc5bums@4ax.com...
    > An alternative to this I use is a separate sessions DB table, where
    > you set a user's ID to active after a successful authentication. That
    > way you don't have to use session variables at all. I also assign
    > unique session IDs so I'm not passing login names as a querystring.
    > This has the added advantage of storing login/logout times depending
    > on how you want to implement it.
    >
    > >Terry
    > >
    > >Presumably you want the pages protected so that, austensibly, only you
    can
    > >access them?
    > >
    > >Create a table in your db with two columns ( 3 if there will be more than
    > >one authorised user - the third being an ID autonumber). Uname and Pword
    > >for example. Enter your chosen words for both columns.
    > >
    > >Create an html form with input type text, input type password and a
    submit
    > >button. Form action Post. Submit to an ASP that compares your input
    data
    > >to your saved data in the db. If both user name and password match, then
    > >set a session variable to true and redirect to wherever you want to go
    next,
    > >an admin menu page perhaps.
    > >
    > >If either user name or password fails to match, set the same session
    > >variable to false and redirect to, for example, unauthorised.html.
    > >
    > >On each page that you want kept private, at the top, place code like
    this:
    > >
    > ><% @ LANGUAGE="VBSCRIPT" %>
    > ><% Option Explicit
    > >If Not Session("adminOK") OR IsNull(Session("adminOK")) = True Then
    > > Response.Redirect("unauthorised.html")
    > >End If
    > > %>
    > >
    > >This will stop the casually curious, but obviously not the determined
    > >hacker.
    > >
    > >HTH
    > >
    > >Peter
    > >
    > >"Terry Murray" <tgmurray@rogers.com> wrote in message
    > >news:kKL0b.206953$4UE.277@news01.bloor.is.net.cab le.rogers.com...
    > >> Hi All:
    > >>
    > >> I would like to have certain areas of a site that I am developing
    password
    > >> protected but I am not sure how to go about doing this. I know that I
    > >> definitely do not want to use Session variables (as the client may have
    > >> cookies disabled). So the other option I guess is to have the
    > >> username/password checked against a database. I am not sure how to
    > >proceed
    > >> with this, though, as there may be more than 1 page that has to be
    > >> password-protected. Most likely all of the password protected pages
    will
    > >> reside in the same directory or at least have the same parent
    directory.
    > >> Any suggestions:
    > >>
    > >> Keep in mind, that at this stage, the database being used is being
    created
    > >> in Access
    > >>
    > >> Thanks in advance
    > >>
    > >>
    > >> Terry
    > >>
    > >>
    > >>
    > >
    >

    Terry Murray Guest

  7. #6

    Default user authentication

    Hi there....
    I need to setup a user authentication (ASP VBScript). An administrator user
    will assign the username and password of the users who will have access to the
    site and then the normal login process for those registered users.
    Any sample application or an extension that might do the above.
    Any input would be appreciated.
    Thanks
    Z

    Zahia~ Guest

  8. #7

    Default Re: user authentication

    read the DW help topics "Site configuration for dynamic sites" and
    "Creating access restricted pages" (or something like this)

    Zahia~ wrote:
    > Hi there....
    > I need to setup a user authentication (ASP VBScript). An administrator user
    > will assign the username and password of the users who will have access to the
    > site and then the normal login process for those registered users.
    > Any sample application or an extension that might do the above.
    > Any input would be appreciated.
    > Thanks
    > Z
    >
    Manuel Socarras Guest

  9. #8

    Default Re: user authentication

    I have some free tutorials which might help you in this area

    [url]http://www.cgw3.co.uk/tutorials/tutorial.asp?TutorialID=31&CategoryID=3[/url]
    [url]http://www.cgw3.co.uk/tutorials/tutorial.asp?TutorialID=37&CategoryID=3[/url]
    [url]http://www.dmxzone.com/showDetail.asp?TypeId=28&NewsId=7645[/url]


    Originally posted by: Zahia~
    Hi there....
    I need to setup a user authentication (ASP VBScript). An administrator user
    will assign the username and password of the users who will have access to the
    site and then the normal login process for those registered users.
    Any sample application or an extension that might do the above.
    Any input would be appreciated.
    Thanks
    Z



    CarlGrint Guest

  10. #9

    Default user authentication

    im having trouble usin the user authentication in dreamweaver mx 2004 for php.
    i v folow tutorials in both web designer and dreamweaver bible. I have followed
    step by step again and again. but the login in nor restrcin access works
    propely, the just act as if the passwords are wrong! is there something im
    missin?
    >select login in user
    >select form
    >select fields
    >select connection
    >select table and colums
    >then if login succeeds goto...
    if login in fails goes to...
    >restric access
    do i need to add a variable of sum sort? o hav never done this b4 and its
    doesnt say anywhere that i need to do:confused;

    Tyler01 Guest

  11. #10

    Default Re: user authentication

    right then i have just been read something sayin that I need to turn register_globals to on, does anyone one know about this?

    Tyler01 Guest

  12. #11

    Default Re: user authentication

    i am using east PHP 1.8
    Tyler01 Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139