RLS on two columns

[Anonymous]

I would like to know how to apply RLS to two columns
where you can see the total sales of the regions in the first
column and only the sales of your own company in the second column.

For example, you are company a .
You can see the total of all sales of the regions but on a detailed level only of your own company A.

[amitchandak · Accepted solution]

@Anonymous , If you want And RLS, add conditions for both in the same role for Or condition have them in a different role. You have email and region and email country table and secure it using that

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk