I have a table “members” and 3 different type of users:
No problems for 1) and 2): I created two groups with different permissions.
But my problem is: how to achieve permissions for 3) ?
I tried assigning the Leads to two groups, but then they will be able to edit all (ref the "most permissive" strategy as described in the manual).
I also tried to create an extra view and then give the Leads read only permissions to the view, but this does not work (Leads still able to edit all data if they also in the group that allow editing their own data).
- Members: they must be able to see/edit only their own data
- Admin: must be able to see and edit data of all members
- Leads: they must be able to see/edit their own data, and also see (but not edit) data of all other members
No problems for 1) and 2): I created two groups with different permissions.
But my problem is: how to achieve permissions for 3) ?
I tried assigning the Leads to two groups, but then they will be able to edit all (ref the "most permissive" strategy as described in the manual).
I also tried to create an extra view and then give the Leads read only permissions to the view, but this does not work (Leads still able to edit all data if they also in the group that allow editing their own data).
