need help to rest sentry admin password

[#1]

Hi ,

we have added a user via ldap and using super user we have given Grants to the added user but when we log-in in hue using the same and later try to execute create table statement its giving us:

• Authorization Exception: User <user> does not have privileges to execute 'CREATE' on: default

as we don't have sentry admin password with us. I need to reset it so that i can log-in using sentry admin and provide the privilege's.

i am thinking it should work. please help if there is another work around for this. 

urgently we need to give privilege's to the added user.

[#2]

@sain Welcome to our community! To help you get the best possible answer, I have tagged in our Hive experts @asish @smruti @tjangid who may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

[#3]

Hi @sain,

What is the CDH/CDP version you are using? If you are using the latest version of CDP, you can grant access via Ranger.

In CDH, the access was managed via Sentry and hence you would need to grant access via Sentry. You can also manage the same via Hue if you have the required privileges:

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/hue_sec_sentry_auth.html 

Let me know if this helps. 

Cheers!

[#4]

hi,

i am using CDH 6.2.0 and its managed via sentry.

we somehow lost admin password. so we are not able to access hue via sentry admin that's why i am trying to understand a way to reset the password so i could give privilege's to the new user.

thanks for your help

[#5]

i have changed sentry admin and now impala cant access database, i have update hue configuration where sentry password was stored. please let me know where i have to update as well.

error message : 

• LDAP server Error: Failed to bind to LDAP server as user Sentry_Admin

[#6]

please reply. sentry admin is not allowing to grant any privilege. so how to reset sentry password and login in hue to give privilege.

[#7]

Hi @sain,

can you please share some error snapshots of where and what exact error you are getting?

[#8]

the issue is resolve by adding user into dlhue group which was also present on ldap. the group is been given previleges by sentry to access hive tables.