10-20-2016 02:47 AM
I am using Sentry on Hive for securing hive tables.
I have two users hive,admin. I am using Hue to manage permissions. I use hive user to login and create a new admin user. I give both users same permissions and add them to all groups i.e. hive and admin. Then I create two roles hive and admin and grant them all permission to read/write database/tables.
I am able to create new tables in metastore manager in Hue through hive user but I get error in case of logging by admin user and doing same in hue. I am worndering why there are no roles found as well which I created using hive user for admin user.
I also get error saying Access denied to user admin when I open security->hive tables by admin user.
Below are the screenshots.
12-13-2016 12:26 PM
The sentry will add default admin group as hive, hue etc. If you want to manage roles via your admin login then you should update your admin group in the following configuration. CM -> Sentry -> Configuration -> sentry.service.admin.group
12-14-2016 12:17 PM
Have you created the users/groups that you have mentioned in OS level (Linux)? if not, you have to match the Hue users/groups to OS users/groups. Pls try this