Row Level Security

Question

Imagine this scenario.2 user groups. &nbsp;A &amp; B which are aligned to sales channels A and B.Each channel contains customers. &nbsp;Lets say A1, A2, A3 and B1, B2 B3&nbsp;Users in group A need to see all sales in channel A and be able to see the detail of sales for A1, A2 and A3. &nbsp;They also need to see an aggregated view of sales for Channel B, but NOT the detail. &nbsp;So all of B aggregated together.&nbsp;Same is true of users in group B. &nbsp;Then need to see all of B sales and B1,B2, B3 but only an aggregated view of sales for A.&nbsp;RLS no good as that would prevent A from seeing any of B and vice versa.&nbsp;What is the solution??amitchandak&nbsp;

amitchandak · Accepted Answer

NimaiAhluwalia , I would advise creating a table having only group-level data, not having customer data, and joining. That will allow you to see that data.
&nbsp;
Other way would have a column and access in RLS table, joining back to Customer, filter from RLS table to Customer. So new column(Customer Share Group) in RLS will be used in visual also
&nbsp;
Customer , Customer Share Group, Email
A1 - A1 - a@email.com
A2 - A2 - a@email.com
A3 - A3 - a@email.com
B1 - B - a@email.com
B2 - B - a@email.com
B3 - B - a@email.com
A1 - A - b@email.com
A2 - A - b@email.com
A3 - A - b@email.com
B1 - B1 - b@email.com
B2 - B2 - b@email.com
B3 - B3 - b@email.com
&nbsp;
This can be intermeditae table if you want to avoid too much of data in RLS

Forum Discussion

Row Level Security

1 Reply

Related content

Dynamic Row level security

Role Level Security

Dynamic Row level security issue

Row level security

Row Level Security