I have 2 users, that have access to 5 streams with its apps and sheets, but there is 1 stream (Sales which has 1 app and 5 sheets) that I want User 1 to have access to 3 sheets and User 2 to have access to 3 other sheets
sheet names;
1 Sales summary
2 CS
3 Budget
4 Service
5 CustomReport
User 1 has access to sheets (1,2,3) user 2 has access to (1,4,5)
I have tried following the links above but I don't get it right it either removes access from both users/ and their other streams or it give access to all.
I don't want the other streams to be affected.
the security I am using is
(resource.resourcetype = "App" and resource.stream.HasPrivilege("read")) or ((resource.resourcetype = "App.Object" and resource.published ="true" and resource.objectType != "app_appscript" and resource.objectType != "loadmodel") and resource.app.stream.HasPrivilege("read")
and ((resource.name!="Budget" or resource.name!="CS") or user.name="User 2")
and ((resource.name!="Service" or resource.name!="CustomReport") or user.name="User 1")
