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
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
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
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

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