Page History
Sv translation | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||
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. User security levels are great way to reduce vulnerability risk, as it allows you to access data belonging only to specific user.
Creating user security levelsOpen 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:
defining query codeThe query is using SQL-like format that will be applied to the selected columns as a filter. The query must apply the following steps:
Query code example
VariablesThe following variables are available:
WildcardYou can use wildcards in BellaDati which allows you to substitute any number of characters
UnionIn case multiple selects are required, use key UNION to join them. JOINIf JOIN is needed, it can be also used in query. JOIN represents LEFT JOIN Applying security levelsOnce 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. Vulnerability risk reduceHere you can see simple example of limiting data only to specific userId. DataSet 26 must contain L_CONN_COL this column will be key for both tables and L_USER_ID. This security can be applied to any other DataSet that has L_CONN_COL which will grant access to specific row. |
...