Is it possible to set default schema

[marchelo]

Hello,

Can I set up an logon script in PL/SQL Dev.
I want it to change the default schema.
For example, running ALTER SESSION SET CURRENT_SCHEMA=... after creation of new session.

Mark.

 

[Marco Kalter]

You can do this in the AfterConnect.sql script from the PL/SQL Developer installation directory. This is a script that will be executed for all sessions created in PL/SQL Developer.

 

[marchelo]

Thank you. I'll try soon this solution.