|
From: Alarcón V. <vla...@ya...> - 2020-11-20 03:17:08
|
Hi, Maybe there's another way of resolving this, but I haven't fonud it: I need to set the default schema for an Oracle connection; otherwise, I need to type the schema on every query I write. In my use case I'm connecting to an Oracle database with a read-only user (production db), and this user does not correspond to the schema where the data is stored. So far, I can see three options: 1. Type the schema on every query. I really don't want to do this. 2. Run the SQL statement: "ALTER SESSION SET CURRENT_SCHEMA prod-schema", every time I connect or reconnect. 3. Stackoverflow says I can create a trigger on my user schema that automatically runs option #2 when connecting. Unfortunately I can't do this since I have read-only access. I was wondering Squirrel SQL's Session Properties could be enhanced with an "Initial SQL Statement" provided by the user. I think Spring implements this strategy at startup. Maybe there's a better way I haven't found yet. Alternatively, if someone tells me where to fix it, I could fork Squirrel SQL and later submit the change. Thanks in advance, Vlad |
