Support Questions
Find answers, ask questions, and share your expertise

Hue db editor permissions

Hue db editor permissions

Master Collaborator

Hi,

 the documentation and resources on the web are little bit confusing about how exactly set up a connection to a RDBMS for Hue4. In a previous version it was called "DB Query" now it is integrated into the "Editor" 

 

I have figured out that following the docs, enabling the [librdbms] (Warning, not the [rdbms]) is not enough, the [notebook] section has to be defined as well. But after the definition of posgre db in the notebook the Impala dissapeared. So I had to add the impala and hive explicitly (Cloudera Manager -> Hue Service Advanced Configuration Snippet (Safety Valve) for hue_safety_valve.ini)

 

[librdbms]
[[databases]]
[[[postgresql]]]
nice_name="PosgreSQL xxxxx"
name=spss
engine=postgresql
host=xxxxxx.rds.amazonaws.com
port=5432
user=hue
password=xxxxxxxxxxxxxx
[notebook]
[[interpreters]]
[[[impala]]]
name=Impala
[[[hive]]]
name=Hive
[[[postgresql]]]
name="PostgreSQL xxxxxx"
interface=rdbms

Now I can see this:

hue.PNG

 

 

 

Now the question is, I created a dedicated group with rdbms.access permission. Nobody has this grant. I tried to log in with a user who did not have this permission and was able to open the PosgreSQL editor.

 

How to restrict the access to the editor? Or is it the permission not working, because the user is superuser?

 

2 REPLIES 2
Highlighted

Re: Hue db editor permissions

New Contributor

Hi Tomas79,

 

I got the same issue here. Have you fixed this problem?

Highlighted

Re: Hue db editor permissions

Community Manager

HI @Tylezen, as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.


Regards,

Vidya Sargur,
Community Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Learn more about the Cloudera Community: