Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2012
    Posts
    7

    Question Unanswered: Web Application using Jsp and Db2

    Hello, I am developing a web application which there will be at least 3 types of users (Admin, Moderator, Operator, Companies, Users, etc..), what I want to do is a log-in page with user name and password, and according to these information user's role will be set and tables which user can access (read/write) will be shown. What do I need to do this? I'm confused about how to do it, any help would be appreciated, thanks in advance...

    Ps: I'm using the latest versions of WAS, DB2, RAD on Opensuse 12.2

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    I would create a cookie on the user computer then when accessing the database add the cookie setting to the where of the SQL
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Nov 2012
    Posts
    7
    Thanks for your reply but I have to use sessions

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by myle View Post
    I would create a cookie on the user computer then when accessing the database add the cookie setting to the where of the SQL
    ... thus allowing anyone in the world to become "Admin, Moderator, Operator, Companies, Users, etc.." just by editing the cookie text?

    I thought in the 21st century nobody does stuff like this anymore.
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    Yes u are right

    But what meant storing a cookie yes but not the value that would be store in the database the cookie session is just a flag

    And yes session would be beater don't forget to have logout it makes the user feel they are in control
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  6. #6
    Join Date
    Nov 2012
    Posts
    7
    so what is your suggestions about designing the database? and giving the rights to users??

Tags for this Thread

Posting Permissions

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