2.4.11.1 Create Product Family Manager Role
Can you give me an example of how one can create selective access for the following?
Each Product Family Manager should be able to make changes to the Volume Growth Rates for only their assigned Product Family, but only view the data for the other three Product Families.
Best Answers
-
You need to go to General list → P1 & P2 Product lists, you will find a checkbox for selective access. Just mark it true, and it's done. Now you need to give yourself access to products from users tab.
0 -
To implement this requirement, we can use an access management system based on certain conditions.
0 -
To achieve selective access, you can use role-based access control (RBAC) combined with data filtering. For example, in tools like Excel with VBA, Power BI, or a database with user roles, you can assign each Product Family Manager a specific role tied to their Product Family. Create permissions such that they have edit rights only for their assigned Product Family and read-only rights level devil 2 for the others. In Power BI, you could use row-level security (RLS) to filter data dynamically based on the user role. For databases, you could create a view or use triggers to enforce this access. This ensures each manager interacts with data as per their responsibility without seeing more than necessary.
1
