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.

Access denied to user admin on Hue for Hive Sentry authorization

Highlighted

Access denied to user admin on Hue for Hive Sentry authorization

New Contributor

Hi,

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.

 

Selection_001.pngSelection_002.png

5 REPLIES 5

Re: Access denied to user admin on Hue for Hive Sentry authorization

Champion

@amkumar

 

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

 

Thanks

Kumar

Re: Access denied to user admin on Hue for Hive Sentry authorization

New Contributor

I have already tried doing that but it worked only when I added system user to the pre-existing sentry admin group i.e. hive.

Re: Access denied to user admin on Hue for Hive Sentry authorization

Champion

@amkumar

 

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

 

Thanks

Kumar

Re: Access denied to user admin on Hue for Hive Sentry authorization

New Contributor
Yes, user group and user existed before adding them to sentry admin group.

Re: Access denied to user admin on Hue for Hive Sentry authorization

New Contributor

Am also facing this issue did you got any resolution for this?

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