This topic is locked

Multi-Level Permissions

10/31/2008 8:28:10 AM
PHPRunner General questions
buddy author

I am having a problem establishing multi-level permissions for a project.
In DB1 I have:
ID

Partner

Company

Name

Moderator
What I need to do is have poeople be able to view/edit their own records (no problem, this works). The Moderator field contains user id's of moderators that can view/edit the records that are in their group. That is what I'm having the problem with.
Any direction would be appreciated. I haven't been able to make it work from the other threads in the forum.
BB

Sergey Kornilov admin 10/31/2008

It won't work if Moderator field contains the list of IDs. You need to have a separate Users table and use User Group Permissions. You also might need create a separate view for Moderators use only.