Version 12.0.3.1821 (32 bit)
I have one personal login and password to database.
But my user has grants to many other schemas.
I have tried to create several different connection definitions with the SAME username but different "Initialization script" and "Message"
1) Connection definition ONE:
Display name: First Databank
Username: user
Database: test
Initialization script: ALTER SESSION SET CURRENT_SCHEMA=DATA_SCHEMA1
Message: You have connected to DATA_SCHEMA1!!
2) Connection definition TWO:
Display name: Second Databank
Username: user
Database: test
Initialization script: ALTER SESSION SET CURRENT_SCHEMA=DATA_SCHEMA2
Message: You have connected to DATA_SCHEMA2!!
It seems to be, than if you define more than one definition for one user - only FIRST definition really works.
When I click on second definition - Initialization script from FIRST definition is applied and Message from FIRST definition is popped up.
When I connecting under my "user" - ALL definitions in Connections window become "Active" (bold font) (This is understandable, it seems to be, than connections identifies by username).
But why second initialization script do not applied and second message do not appear, when I choose second connection definition - I can't understand.
I have one personal login and password to database.
But my user has grants to many other schemas.
I have tried to create several different connection definitions with the SAME username but different "Initialization script" and "Message"
1) Connection definition ONE:
Display name: First Databank
Username: user
Database: test
Initialization script: ALTER SESSION SET CURRENT_SCHEMA=DATA_SCHEMA1
Message: You have connected to DATA_SCHEMA1!!
2) Connection definition TWO:
Display name: Second Databank
Username: user
Database: test
Initialization script: ALTER SESSION SET CURRENT_SCHEMA=DATA_SCHEMA2
Message: You have connected to DATA_SCHEMA2!!
It seems to be, than if you define more than one definition for one user - only FIRST definition really works.
When I click on second definition - Initialization script from FIRST definition is applied and Message from FIRST definition is popped up.
When I connecting under my "user" - ALL definitions in Connections window become "Active" (bold font) (This is understandable, it seems to be, than connections identifies by username).
But why second initialization script do not applied and second message do not appear, when I choose second connection definition - I can't understand.
Last edited:
