For the past month I've been developing a database managemnet
system for a department in my university. It's nothing super
complicated, but considering the fact the we are a music college
and I have no formal training in web development, it turned out
pretty good. For this application I created a vey simple login
system using PHP and MySQL, but now i've been asked if it would be
possible to add custom user groups with different privileges.
I was wondering what would be the best design for such
feature, or if there is some sort of template I can base this
system on. Right now what I have in mind is to store true/false
information in a "usergroup" table as a serialized array and use
this data as visible or enabled properties of the various sections
inside the application. I don't know, but this doesn't really seem
a good design to me especially considering that new sections might
get added in the near future.
I'm here to see if there is somebody so kind to give me some
advice. Thank you very much for your time.