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.

setup user level access to hive database

setup user level access to hive database

I have to setup user level access to database. I want to setup read write access for specific users on hive database as give below.

e.g. i have hive database db1 and users user1 and user2. Want to setup below access for users db1 -> user1 all access(Read, Write, create, delete, update) user2 only Read access(Read)

3 REPLIES 3

Re: setup user level access to hive database

Expert Contributor

Re: setup user level access to hive database

@Alpesh Virani

Please try to use Ranger. You should be able to do that:

Hope this link helps you : https://hortonworks.com/blog/best-practices-for-hive-authorization-using-apache-ranger-in-hdp-2-2/

Highlighted

Re: setup user level access to hive database

Can i use knox instead of ranger?

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