DB Structure for menu/security groups
Attempting to setup a menu with security groups and users. My general question is, how would the db Structure look for something like this? If I have a users table and each user is assigned a security group (another table). Then that security group is assigned to certain menu options. It would generally work if most people did similar things so there doesn't need to be a ton of security groups, however, each person needs access to maybe one different menu option/screen than the next so i feel like this would leave me with just a ton of security groups. So in that case should it be by the user then instead of security groups? Not sure. Any thoughts on how to setup something like this? I am very open to any ideas. Thanks!
Often have questions like this?
Learn more efficiently, for free:
