Session improvement request - CURRENT_SCHEMA

[Max Castagno]

Hi,
what about introducing a feature for a specific "session" or for the "main session" to enable a "global" ALTER SESSION SET current_schema = XXX applied, on demand, to all the windows open using the same connection?

Many times I use an administrative account to retrieve code and info from SQL Area and packages from other schemas....
For complex SQL statements it is difficult (or time consuming) to introduce, for example, the schema prefix for tables just before executing the "explain window" on the same code (an alter is done in SQL window and must be executed on the "explain window" too....

Is it possible to insert the request for future releases?

Thanks

Max

 

[Bernhard S]

I would appreciate a feature like that too. For security reasons we often have a strict split between schemas which contain schema objects but lack connect privileges and schemas which containt no schema objects but provide connect privileges and object privileges to those object schemas.
In that case you're forced to either use ALTER SESSION SET current_schema = XXX or schema prefixing all the time.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Max Castagno]

Hi Guys,
any news about this feature.
It would be extremely useful for me at this moment because i'm testing API's that generates and logs complex statements in the application schema that is the one at witch I connect.
Thanks
Max

 

[Marco Kalter]

You can add an alter session statement to the initialization script of the connection definition. Go to Configure > Connections, select the connection, click on the "Initialization" tab and enter:

ALTER SESSION SET current_schema = XXX;

 

[Max Castagno]

Thanks Marco
this is great.
Have a great evening

Max