
Thank you for taking the time to read my question.
In my canvas app I need to restrict the data a user can see. In my case User 1 should only see business 1,2,3,5 where as User 2 should only see 1,3,4,5,6
In the past I've done this using IN. I make a column in my User table and store a string which is all the businesses that user should have access to. Then I compare that string with the Business Name field in my data table using the IN function. Of course performance will suffer as my data table grows.
Note: My data is in SharePoint lists.
I read Row Level Security for Dataverse but I'm not really sure that is what I need as the admins of the app could add more businesses and need to assign them to Users.... or maybe remove businesses from users. There is on one role that defines what a User should have access to... there could be as many Roles as Users...
Thanks!
Hello,
Dataverse is designed for this :
You can set user's security role to read/write/create only records owned by their team / business unit / or themselves
You can set a Manager security role to read/write everything
You can add users to the teams matching the records they have to see
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily.