Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Allowing automatic Schema switching after connection login in Sql Developer

user13005549Sep 21 2017 — edited Sep 22 2017

Hello,

I use SqlDeveloper since 4 years and I connect to an instance GWHP (that is the name of the instance on your system) using my Oracle Userid.

Just after Login, I enter a command to change the schema.

example: ALTER SESSION SET CURRENT_SCHEMA=TLGADBA

Is there a possibility on Sql Developer to connect using a specific Userid and to be immediately (after login) in another Schema without using SchemaBrowser or without giving ALTER SESSION command ?

If then is not possible, I have the following Change Request

Can Oracle add the DEFAULT-SCHEMA new field in connection definition dialog box and used the value in this field (if not empty) to change of schema just after login ?

Another solution would be to add a AFTER-LOGIN-CMD new field that contains a SQL command (or more separated by comma) that is immediately executed after successfull login.

This last solution will give more freedom; because it is possible to call a Sql procedure that changes schema but also that can change others parameters.

Personaly, as developper, I will implement the 2 solutions :-)

If this new enhancement is implemented, I can than define 2 or 3 connections with my userid that point each to a different schema !

Example:

PROD-schlebe-TLGADBA

PROD-schlebe-GWHDBA

PROD-schlebe-SKUDBA

where schlebe is my Userid and the name after defined the others schemas.

Is there a good idea ?

Can a Oracle Sql Developper ... developper implement it ?

-Bernard

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2017
Added on Sep 21 2017
9 comments
1,653 views