[eluser]megabyte[/eluser]
In a nutshell I'm designing a custom cms. Its designed where there are 2 major permissions.
A company admin, and a site admin
The company Admin has access to all sites
The site admin has access to 1 to (n) number of sites
right now I have it so they select checkboxes for each site they are given rights to, then I keep this list as a comma deliminated string under their profile in the db table.
Should I be keeping it in its own table as individual entries instead?
ie.
table
userid site
1 2
1 4
1 4
1 6
1 8
like that instead.
I realize there ae many mways to solve a problem.
Has anyone ever tackled this before? If so, how did you structure your db, and how did you structure your form.