What is the best way to implement authentication with groups
Posted: Tue Jun 13, 2006 1:18 am
Please forgive me if this is not the right place for this question.
I would like to create a security model where all intended users will have access to the system from a single point of entry. The intended users are:
- company employees (including regular emplyees by department and administrator users)
- customers
- vendors
- suppliers
Each group of users will only be given access to certain sections and each user within the group have access to their personal items as well as some predefined group accessible items.
I was thinking about creating a single table with the usernames/passwords and then a separate table for each group (eg. one for customers, one for vendors, one for suppliers, one for employees, etc)
The customer records are in the thousands and employees may be delegated certain tasks so I thought that if I separated the employees from the customers, it would narrow down the list when selecting employees for delegation.
Any input on how to best do this would be greatly appreciated.
Kind regards,
I would like to create a security model where all intended users will have access to the system from a single point of entry. The intended users are:
- company employees (including regular emplyees by department and administrator users)
- customers
- vendors
- suppliers
Each group of users will only be given access to certain sections and each user within the group have access to their personal items as well as some predefined group accessible items.
I was thinking about creating a single table with the usernames/passwords and then a separate table for each group (eg. one for customers, one for vendors, one for suppliers, one for employees, etc)
The customer records are in the thousands and employees may be delegated certain tasks so I thought that if I separated the employees from the customers, it would narrow down the list when selecting employees for delegation.
Any input on how to best do this would be greatly appreciated.
Kind regards,