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