Here is an example of a security level definition.
- today's date is 11.11.2020
- User info is set to 11
We will be using this query:
This query will be used as an example of how to use JOIN or variables.
We will be applying our restriction to column L_PARTITION
From the last table where we applied our security level, the logged user will get only rows where Partition value is 1 (orange colour)