question Re: SWICHDATABASE privilege missing error in HUE. User can't access to Hive tables. in Support Questions

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

hparteaga — Fri, 16 Sep 2022 12:33:05 GMT

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.

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

Tomas79 — Sun, 26 Nov 2017 20:22:36 GMT

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.

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

Tomas79 — Sun, 26 Nov 2017 20:23:01 GMT

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

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

hparteaga — Mon, 27 Nov 2017 11:27:24 GMT

Hello @Tomas79, thanks for your answer.

As seen above, I get the same error.

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

hparteaga — Mon, 27 Nov 2017 13:07:03 GMT

SOLVED

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

groupadd reg_group
useradd -g reg_group user_reg

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

quangbilly79 — Thu, 18 May 2023 06:48:46 GMT

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