Thank you for your reply!
Of course, I have no plans to create so many BUs for just one project. It is insane.
The overall requirement is below:
Users U1, U2 need to provide inputs related to a category C1. Both should be able to see each other's inputs so that they can collectively submit the details for the category C1. Their manager M1 takes approval to be assigned to category C1. S/he should be able to review and approve their inputs for closure.
The expectation is same for users U3,U4,U5 and their manager M2 for another category C2.
U1,U2 and M1 should have access to the data of category C1 only. U3,U4,U5 and M2 should have access to data related to category C2 only.
Manager (M3) of M1, M2 will take approval for both categories C1 and C2. S/he should be able to access both categories data.
Point to note is user's access is dependant on the categories they take approval for.
For any reason, if admin revokes a user's access to a category (M3 loses access to category C1 data but M3 will still have access to category C2 data).
Admins who approve the requests and run this project should have access to all of this data. So, I plan to give Organization level permission in the security role I assign to them.
Their inputs will have detailed questions and corresponding responses with One-to-Many relationship. Hence, I am saving their inputs in two tables with aforementioned relationship.
I hope I outlined the requirement for your understanding.
Please let me know if I have to share more details.
Regards,
Jigyasa
