question Re: need help to rest sentry admin password in Support Questions

need help to rest sentry admin password

sain — Thu, 12 Oct 2023 05:29:21 GMT

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.

Re: need help to rest sentry admin password

VidyaSargur — Thu, 12 Oct 2023 06:53:34 GMT

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

Re: need help to rest sentry admin password

tj2007 — Thu, 12 Oct 2023 06:58:51 GMT

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!

Re: need help to rest sentry admin password

sain — Thu, 12 Oct 2023 09:26:44 GMT

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

Re: need help to rest sentry admin password

sain — Mon, 16 Oct 2023 07:24:13 GMT

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

Re: need help to rest sentry admin password

sain — Tue, 17 Oct 2023 10:59:47 GMT

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

Re: need help to rest sentry admin password

tj2007 — Thu, 19 Oct 2023 04:11:23 GMT

Hi @sain,

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

Re: need help to rest sentry admin password

sain — Mon, 23 Oct 2023 08:04:08 GMT

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.