Hi All,
I have never tried to restrict what a person has access (Not Intended As A Joke) to. But my current class assignment requires that I present specialized switchboards to users based upon their credentials. The switchboards are not the problem - creating users, groups, etc. is. And then to deploy this system after they first log in, I expect, is another matter altogether.
For example, the den leader would need the ability to monitor everything in the database, including setting up the troop in the first place. He also creates users and groups, and is in charge of passwords. Then he creates users who perform various tasks within the troop.
For example, one of the cub scouts takes role at each meeting, and should only gain access to forms and reports pertaining to attendance.
Another boy takes care of recording whether they earned a particular badge, and then making sure someone orders it, and eventually pins it on who earned it.
This feels typical to the things most of you professionals do every day. And though mine is a labor of love, it still covers the same ground you have already covered. As a consequence, I would be overwhelmingly grateful if someone has already developed something along these lines would zip up the whole thing and send it to me.
Thanks a 1,000,000
Chuck