Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Impala/Hive : Sentry Row Level Security on User (not group)

Impala/Hive : Sentry Row Level Security on User (not group)

New Contributor

Hi,

 

 I know, row level security can be achived via views in Sentry. And also roles can be applied on groups only.

 

 My question is, by any chance can i apply role on user.If not, can we expect it in future version?

 

I need it for the below,

 

     We have a case in legacy database where there is a view which fetches rows from two to three different tables. From Tableau, user  information is fetched and used in view’s where clause ( like select * from <viewname> where user=xxx) when the report is loaded. So that only the restricted data can be viewed by the user. Can we implement the same in sentry?

 

My understaning is , in sentry,  for this case; we need to create different views for each user( one per group) which is not accepted because of redhat groups limitations and need more number of roles. 

 

Or could you please help me if you have any other alternates if any.