Forum Discussion

NimaiAhluwalia's avatar
NimaiAhluwalia
Continued Contributor
2 years ago
Solved

Row Level Security

Imagine this scenario. 2 user groups.  A & B which are aligned to sales channels A and B. Each channel contains customers.  Lets say A1, A2, A3 and B1, B2 B3   Users in group A need to see all sa...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
2 years ago

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.

 

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

 

Customer , Customer Share Group, Email

A1 - A1 - [email protected]

A2 - A2 - [email protected]

A3 - A3 - [email protected]

B1 - B - [email protected]

B2 - B - [email protected]

B3 - B - [email protected]

A1 - A - [email protected]

A2 - A - [email protected]

A3 - A - [email protected]

B1 - B1 - [email protected]

B2 - B2 - [email protected]

B3 - B3 - [email protected]

 

This can be intermeditae table if you want to avoid too much of data in RLS