Link to home
Start Free TrialLog in
Avatar of geocoins-software
geocoins-software

asked on

Adding a User Account Security System of tables

Not sure if this was the correct thread to ask this question, but i figured it was good as anywhere
I am drawing up some preliminary dessigns of a user account security system for an application.

I will explain what I have and what I want, and someone can explain what I should need.

I was thinking I would like a User Account Security System for an application (not yet developed).

The Idea would be to have users, who belong to groups, which have x number of rights.
The administrative user would of course belong to all user groups and having all rights.

The rights would then be used to give access to users to certain functionality of the application.

I have built some preliminary tables.  See attached image of tables.
There are additional fields to be added to Users table which i have left out for simplicity.

Any ideas, suggestions, or help with the tables would be appreciative

thanks

USERS
-----------
Id
User_Name
Password
Last
First


USER_GROUPS
------------------------
Id
Group_Name
Description


USER_RIGHTS
----------------------
Id
Right_Name
Description

tables.jpg
Avatar of geocoins-software
geocoins-software

ASKER

Sorry, I forgot to mention......i am not sure how i would implment the User Groups belonging to the Users

and/or implement the User Group Rights belonging to the User Groups

see my rework of the tables below

USERS
-----------
Id
User_Name
Password
Last
First
User_Groups (Example: 1, 3, 4, 5, 9,etc)

USER_GROUPS
------------------------
Id
Group_Name
Description
User_Group_Rights (Example: 3, 9, 21, 31)

USER_RIGHTS
----------------------
Id
Right_Name
Description


thanks  again
ASKER CERTIFIED SOLUTION
Avatar of Mike Littlewood
Mike Littlewood
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
O and if you don't want to write your own, TMS have one based on the same sort of principle which looks nice.
http://www.tmssoftware.com/site/tss.asp