...
1. Select ‘Row Level Filter’ tab
2. Add a policy to specify row-filters for various user groups, as shown below:
Query Results
...
Please note that multiple policy-items in the previous use case, one for each user-group, are replaced with a single policy-item in the updated policy below.
Query Results
...
where ec.userid = current_user())
Query Results
...
In this case, since no filter is specified for user falcon, the user will be allowed access all rows.
Query Results
...
Follow the steps given below to create a policy to enforce masking on the column:
1. Select ‘Masking’ tab
2. Add a policy with the following details:
Query Results
...
Add a policy with the following details:
Query Results
...
Add a policy with the following details to specify the expression, initcap(reverse({col})), to transform name_first column values. Ensure that the datatype of the expression is same as the datatype of the column. Token ‘{col}’ in the expression will be replaced by Apache Ranger policy engine by the name of the column on which masking is being applied.
Query Results
...