Hi,
I have a dataverse based model driven app that lets users create records in a custom table "cases". "cases" is accessed with a security role with row based rw per user. For each case, the user has to chose a user from a distinct set of other systemusers as the manager of this case. The manager needs to have rw rights on all the records where he is selected as the manger. All other users have no access rights to the record.
| Record | Owner | Manager |
| 1 | User 1 | User 11 |
| 2 | User 1 | User 12 |
| 3 | User 2 | User 11 |
For the moment I handle this with sharing the record with the specified manager with a power automate flow. But I read multiple times that automatic sharing is really bad for a couple of reasons (performance, manageability...).
How would you accomplish these security requirements without using sharing? Would you use automatically created Access-Teams?
Security - Part 5 | What is Access Team? | How to Configure Access Team? | Dynamics CRM 365 - YouTube
How to Add Users to an Access Team with Power Automate (mibar.net)
