Hi All,
I'm working on creating a Dataverse table that will contain a significant number of rows. Each row will include a specific column designated for determining view access rights. This column will list individual names, and the primary requirement is to allow individuals to view only the rows pertaining to their name.
However, there's a hierarchical aspect to consider as well. For certain users, like managers, the need exists to view all data relevant to their team or department. Essentially, while most users should have access restricted to their specific data, some users (based on their role or position in the hierarchy) should be able to view data across multiple rows.
I'm seeking guidance or best practices on setting this up efficiently and securely within Dataverse. What are the recommended approaches or strategies to implement this kind of hierarchical, role-based access control?
Any insights or suggestions would be greatly appreciated.
Thanks in advance.
