DB Structure for menu/security groups

Question

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!

Answer 1

Considering the thread topic (database), and having DB structure mentioned; would you mind adding SQL to the thread tags?

* I'll drop this note soon.