setup user level access to hive database

[#1]

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)

[#2]

@Alpesh Virani

you can set it up using Ranger policies:

https://hortonworks.com/hadoop-tutorial/manage-security-policy-hive-hbase-knox-ranger/

[#3]

@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/

[#4]

Can i use knox instead of ranger?