Hi All,
I'm currently working with a Dataverse table where all the necessary records are already uploaded, and I do not plan to add any new rows. My goal is to set up a system where users can have general read and write access to the table, with the understanding that different security roles will have varying levels of privileges.
The challenge I'm facing is how to indicate ownership or assign a specific record to a particular user within this structure. This is crucial for implementing role-based access control effectively, ensuring that users can only interact with records relevant to their role or assigned to them.
To give a bit more context:
- The table is already populated with all the data needed.
- I am not looking to modify the structure of the table or add new records, just to manage access.
- The idea is to have different security roles with distinct read and write privileges.
Could anyone advise on the best approach to assign or denote which record belongs to which user in this scenario?. Are there specific properties or configurations within Dataverse or Power Apps that facilitate this kind of role-based record access?.
Thanks in advance.
