Hi,
I need to set the default schema for a specific session in HANA.
Why?: I have a third party application which gets access to a specific tenant of a SAP HANA DB via a system DSN and then login with a specific user. This 3rd Party app also creates tables in the respective tenant and in the default schema of the user who was used for the login. However I want to have control about in which schema these tables are created by the 3rd Party app. I do not want to use the default schema of the "working" user.
In HANA I would have the possibility to execute SET SCHEMA <Schema> to set another schema as default schema for the current session of the user who executes this command. Within the 3rd Party app I do not have an SQL editor or other means to execute that command. So the idea would be to execute SET SCHEMA <Schema> e.g. in HANA Studio for a specific session of the user who already logged in via the 3rd Party app.
Is this possible?
The 3rd Party app in question is ArcGIS Pro 2.1 of Esri. The same requirement for the Predictive Analytics solution was solved with a configuration file of the application. To my knowledge ArcGIS Pro 2.1 does not provide this.
Thx, Ingo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.