Support Questions
Find answers, ask questions, and share your expertise

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
Highlighted

Re: setup user level access to hive database

Expert Contributor
Highlighted

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?