Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the Community News blog.

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

SOLVED Go to solution
Highlighted

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

Explorer

imagen.pngSWITCHDATABASE privilege missing when trying to run a selectimagen.pngPrivileges 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

Accepted Solutions

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

Explorer

SOLVED

 

 

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

 

 

groupadd reg_group
useradd -g reg_group user_reg

 

4 REPLIES 4

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

Master Collaborator
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.

Master Collaborator
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.

Explorer

image.png

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.

Explorer

SOLVED

 

 

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

 

 

groupadd reg_group
useradd -g reg_group user_reg