Hi All,
We are looking for a solution where two different teams should have access on single record with different permissions level.
Scenario:
1. We have company table with department and parent department columns along with other columns.
2. We have created Teams per department with read and write permissions and per parent department with read permissions.
Sample data in company:
| Department | Parent Department |
| Department 1.1 | Parent Department 1 |
| Department 1.2 | Parent Department 1 |
| Department 2.1 | Parent Department 2 |
Teams and users
| Team | Users | Permissions |
| Team Department 1 | User A | Read |
| Team Department 1.1 | User B, User C | Read, Write |
| Team Department 1.2 | User D, User E | Read, Write |
| Team Department 2 | User F | Read |
| Team Department 2.1 | User G | Read, Write |
Now,
1. User A should have access to all Department 1 records with Read access.
2. User B and User C on Department 1.1 with Read and Write
3. User D and User E on Department 1.2 with Read and Write
4. User F on Department 2.1 with Read
5. User G on Department 2.1 with Read and Write
We are completely trying to automate this process. We tried manually by using Sharing option where we need to specify permission level for each though we have set required security role with same permission level to respective teams.
We are looking other option where we no need to specify permission level and directly use respective teams
Primary goal is to have two set of users are having access on single record with different permission levels.
Thanks in advance!!!
