08-09-2018 05:04 AM
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:
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?