Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

SWICHDATABASE privilege missing error in HUE. User can't access to Hive tables.

avatar
Explorer

SWITCHDATABASE privilege missing when trying to run a selectSWITCHDATABASE privilege missing when trying to run a selectPrivileges the user has.Privileges the user has.

Working in Hue, I want this user "user" to access Hive tables.

 

As seen in the images, in the context of a proof of concept. User have privilege to any action on the server. However, when I try to run a simple select * in Hue, I got a SWITCHDATABASE missing privilege error.

1 ACCEPTED SOLUTION

avatar
Explorer

SOLVED

 

 

So I skipped to add the user/group to the unix system...

 

 

groupadd reg_group
useradd -g reg_group user_reg

 

View solution in original post

5 REPLIES 5

avatar
If the user really has a server ALL, then he can do anything. So I beleive, that the users group is not resolved correclty to a "regular_group" and therefore the Query does not pass throught the security check.

avatar
You can check it by SHOW CURRENT ROLES what priviliges you have under this user

avatar
Explorer

image.png

Hello @Tomas79, thanks for your answer. 

 

As seen above, I get the same error.

avatar
Explorer

SOLVED

 

 

So I skipped to add the user/group to the unix system...

 

 

groupadd reg_group
useradd -g reg_group user_reg

 

avatar
Contributor

Where do you get/access to this kind of UI? I'm stuck with the user-group thingy when working with Sentry too.

quangbilly79_0-1684392512571.png