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.

Grant Hive wildcard tablename* to Sentry role

Highlighted

Grant Hive wildcard tablename* to Sentry role

Expert Contributor

Hello Sentry experts,

@mszura

 

I am trying to give access to a set of Hive tables within a database with a specific prefix say to my_table1, my_table2, my_table3 etc.

 

For example I gave the below privilege to a role myrole:

server=server1 db=mydb table=my* action=ALL

 

However the wildcard doesnt work. I need to specifiy the tables explicitly like:

server=server1 db=mydb table=my_table1 action=ALL

server=server1 db=mydb table=my_table2 action=ALL

It is pain if we have lots of tables and new tables wont get the permission automatically. How can this tablename*  wildcard be possible in Sentry. We use CDH 5.16 with kerberos.

 

Don't have an account?
Coming from Hortonworks? Activate your account here