You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi,
in my setup I have HUE connected to oracle database where user is allowed to select from multiple schemas.
The issue I am facing, when selecting a schema in the database selection, the schema is not automatically added to the Query so we always have to remember to type in owner.table_name in every select.
Is there a way to activate automatic execution of "ALTER SESSION SET CURRENT_SCHEMA = your_schema_name;" before every select when a schema is selected in the database section?
Thanks
Michael
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
-
Hi,
in my setup I have HUE connected to oracle database where user is allowed to select from multiple schemas.
The issue I am facing, when selecting a schema in the database selection, the schema is not automatically added to the Query so we always have to remember to type in owner.table_name in every select.
Is there a way to activate automatic execution of "ALTER SESSION SET CURRENT_SCHEMA = your_schema_name;" before every select when a schema is selected in the database section?
Thanks
Michael
Beta Was this translation helpful? Give feedback.
All reactions