Dynamic Row Level Security (DRLS) can be implemented by defining a table that contains 1. values for the column to be secured; 2. defining the users email-addresses.
With this specific case, two DRLS columns are defined.
This is shown as depicted in the first picture below:
The first column (_Retailer_Key).
The second column to be secured is also dynamically defined (_CountryAccess_Key):
This works, however suppose I have 4 retailer country combinations
And the _CountryAccess_Key that was defined by DRLS was “UK” and the Retailer was YourOwn, then the Result is that the rows with the red font is returned. This is just (_CountryAccess_Key OR _Retailer_Key). However that’s not the result required. The result should be (_CountryAccess_Key AND _Retailer_Key) as depicted below.
Now the result only returns one row (depicted in the red font)
How can that be achieved within TX?
With kind regards,
Ronald van Koutrik
Best answer by rory.smithView original