Reply
Master
Posts: 368
Registered: ‎07-01-2015

Hue db editor permissions

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?

 

Announcements