Reply
Explorer
Posts: 9
Registered: ‎11-15-2017
Accepted Solution

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

[ Edited ]

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.

Expert Contributor
Posts: 152
Registered: ‎07-01-2015

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

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.
Expert Contributor
Posts: 152
Registered: ‎07-01-2015

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

You can check it by SHOW CURRENT ROLES what priviliges you have under this user
Explorer
Posts: 9
Registered: ‎11-15-2017

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

[ Edited ]

image.png

Hello @Tomas79, thanks for your answer. 

 

As seen above, I get the same error.

Highlighted
Explorer
Posts: 9
Registered: ‎11-15-2017

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

[ Edited ]

SOLVED

 

 

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

 

 

groupadd reg_group
useradd -g reg_group user_reg

 

Announcements