Introduction
Applying strict security rules in one of the oldest known problems in IT. Nowadays it is especially important because data leaks have grown to become one of the biggest challenges for modern companies, often resulting in significant financial losses.Data security in Querona
Querona comes with easy to use mechanism for ensuring data security in both a column-based and a row-based manner using arbitrary rules. As an example, we will show how to limit data visibility based on the role assigned to the given user. We will base on the sample setup described in one of the previous posts about using Integrated Authentication. Let’s assume we have a standard table of customers:
Row-level, role-based security
Let’s begin by adding a new role. Go to Administer -> Role Management -> Add Role:




Dynamic Data Masking
Now let’s change the model a bit and assume the German Managers will see all customers, but the address column holding non-German addresses will be masked for them. Go back to table edit view and remove the table filter and click Save:



Thank you and keep virtualizing!