Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder musher's Avatar
    Join Date
    Jan 2005
    Thanked 0 Times in 0 Posts

    Suggestions on setting up security / login system for a site

    Looking for IDEAS.
    I currently have a standard User-Id/Password login to a web site maint area, I am trying to figure out what would be the best way to add some functionality to it. What I want to try and do is set it up so there are different access lvls (IE. add pages, delete page, edit page type 1, edit page type 2, utitlity section, add users)
    Current MySQL DB has a table with User-ID, Password fields and I was thinking of adding a True/False field for every section but it seems like that could get kind of bulky to me.
    Jim M

    "Lord, help me to become the person my dog thinks I am" - Dawn Ewing
    "If you must know. Yes, I do enjoy running after the dog sled when I fall off" - Me

    www.huskyzone.com -- Woodland Siberians

  • #2
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Thanked 637 Times in 625 Posts
    One design concept I've seen is you have a couple of tables. A "Profile" table stores a profile name and ID and not much more. An "Access" table lists processes/transactions/etc each profile it can access, using profile ID as foreign key. Then you assign a profile to each user. You create as many profiles as you have unique combinations of access in the system.

    The advantage to this is you can change access to an entire group of users by just changing a single profile without having to change every user in the group.


    Posting Permissions

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