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

[#1]

SWITCHDATABASE privilege missing when trying to run a selectPrivileges 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.

[#2]

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.

[#3]

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

[#4]

Hello @Tomas79, thanks for your answer. 

As seen above, I get the same error.

[#5 · Accepted solution]

SOLVED

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

groupadd reg_group
useradd -g reg_group user_reg

[#6]

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