ranger-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vishal Khare (Jira)" <j...@apache.org>
Subject [jira] [Commented] (RANGER-3085) Require column masking based on the value of another column
Date Wed, 09 Dec 2020 08:53:00 GMT

    [ https://issues.apache.org/jira/browse/RANGER-3085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17246368#comment-17246368
] 

Vishal Khare commented on RANGER-3085:
--------------------------------------

[~bosco] - It is in an Oracle table. One user can be mapped to multiple departments.

> Require column masking based on the value of another column
> -----------------------------------------------------------
>
>                 Key: RANGER-3085
>                 URL: https://issues.apache.org/jira/browse/RANGER-3085
>             Project: Ranger
>          Issue Type: Improvement
>          Components: admin, Ranger
>            Reporter: Vishal Khare
>            Priority: Critical
>              Labels: features
>
> Right now, I can create a custom hive function and configure it to enable masking on
the masking screen. The column that needs to be masked will be provided as a parameter to
the custom hive function that I create.
>  
> There is a requirement to mask a column of only certain rows based on some logic depending
on another column that do not needs to be masked.
> E.g - Lets' say there are 5 columns in my hive table namely name, age, dept, salary and
username.
>  
> If Employee 1 belongs to 'A' department. He should be able to see salary for only 'A'
employees. However all others rows should also be returned to Employee 1 but their salary
column should be masked.
>  
> This requirement is critical to our use case because of which we are not able to utilize
ranger. Any help would be appreciated.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message