Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

1. Select ‘Row Level Filter’ tab

Image Modified

 

2. Add a policy to specify row-filters for various user groups, as shown below:

Image Modified

 

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.

Image Modified

Query Results

...

                      where ec.userid = current_user()) 

Image Modified

Query Results

...

In this case, since no filter is specified for user falcon, the user will be allowed access all rows.

Image Modified

 Query Results

...

Follow the steps given below to create a policy to enforce masking on the column:

1. Select ‘Masking’ tab

Image Modified

2. Add a policy with the following details:

Image Modified

 

Query Results

...

Add a policy with the following details:

Image Modified

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.

Image Modified 

Query Results

...