Forum Discussion
Solved
Row Level Security
Hi All, I need to achieve dynamic row-level security for the area, country, and territory columns. I can do it for both area and country but I am unable to find the solution for territory. 1....
Shreeram04 i would suggest you to create a calc column in your table based on country and territory and then apply RLS on that column.
Your new column could be like
country_territoy = tab[Country] & "|" & Tab[territory]
in that way it filter correctly. In your current situation, you have noth, west, south and east territory in many countires.
Shreeram04 i would suggest you to create a calc column in your table based on country and territory and then apply RLS on that column.
Your new column could be like
country_territoy = tab[Country] & "|" & Tab[territory]
in that way it filter correctly. In your current situation, you have noth, west, south and east territory in many countires.