User security level enables creating advanced data level access definition. The definition is based on the specified filter which is applied to the selected data sets
Only users with Domain administrator roles assigned are allowed to create and manage user security levels. |
Open the Data sets page from main menu on the top of the screen.
The dialogue window Add user security level allow users define a security level that can be assigned to selected data sets. The following parameters are available:
The query is using SQL-like format that will be applied to the selected columns as a filter. The query must apply the following steps:
SELECT PT.L_COMPANY, PT.L_LEDGER, PT.L_FIELD from $mainDataset(210) PT JOIN $dataset(208) JD1 ON (PT.L_COMPANY= JD1.L_COMPANY AND PT.L_LEDGER=JD1.L_LEDGER AND PT.L_FIELD=JD1.L_FIELD) JOIN $dataset(209) JD2 ON (PT.L_CODE = JD2.L_CODE AND JD1.L_SHARED_CD = JD2.L_SHARED_CD) where ((JD1.L_USER = '$user(username)') AND (PT.L_COMPANY like '$@reportVariable1')) |
The following variables are available:
user variables | report variables |
---|---|
In case multiple selects are required, use key UNION to join them.
Once a user security level is specified, it can be assigned to a data set. In order to do that, open data set detail and follow the below steps:
Applied user security levels are displayed on the user security level screen:
New levels can be added by using the option Add existing level. Selected user security levels can be unassigned by using X button.