Hi everyone,

I'm setting up a business-to-business website, and I need some advice.

When users login, I want them to have access to a 'section' and they will be able to create 'categories' within that section. Some users will have access to the same section, other will have access to different sections.

How do you recommend I set up my database tables?

Any thoughts would be great. Thanks!

I guess that you should organize it like user groups in unix, but wih a little difference. Every user has unique id and may belong to one or more groups. Every group also has unique id. Every 'section' may be accessed by a number of certain groups.

In this case your tables will be like this:
users: id, name, ...
groups: id, name, ...
ug: user_id, group_id
sections: id, name, ...
sg: section_id, group_id, ...

For perfomance purposes you may cache section-user pairs in separate table and update it when user groups change or group is deleted.

Hi,
i want to help you, so please explain more aboutthe sections and categories with some examples, that will be very helpfull

Thanks for everyone's help.

mtishetsky: I sketched out your table schema and pretty much implemented what you suggested. Thanks!