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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
http://www.tmssoftware.com/site/tss.asp
ASKER
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