[ 
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)

Reply via email to