guttormvik
Member²
I have a db trigger that changes current schema to X.
I added a connection to pl/Sql developer, logged on with user Y, and got the expected schema X.
In the connection list, the connection showed with postfix "[X]"
So far so good.
After logging off, the connection still showed with postfix "[X]"
A bit strange.
Then I dropped the trigger and logged on again.
The current schema was still X and the connection still showed with postfix "[X]" !
Deleting the connection and recreating it in pl/sql developer still showed postfix "[X]", also before I logged on, and logon changed current schema to X.
Logging on with sqlplus gave the expected schema==user
So, it looks like pl/sql developer remembers the current schema after logon, and on later logons also sets it?
What is going on here?
Btw, I should mention that the logon trigger was initially an "after logon on database" and then it was corrected to "after logon on schema".
Not sure if that affects any of the above.
pl/sql developer Version 15.0.4.2064
I added a connection to pl/Sql developer, logged on with user Y, and got the expected schema X.
In the connection list, the connection showed with postfix "[X]"
So far so good.
After logging off, the connection still showed with postfix "[X]"
A bit strange.
Then I dropped the trigger and logged on again.
The current schema was still X and the connection still showed with postfix "[X]" !
Deleting the connection and recreating it in pl/sql developer still showed postfix "[X]", also before I logged on, and logon changed current schema to X.
Logging on with sqlplus gave the expected schema==user
So, it looks like pl/sql developer remembers the current schema after logon, and on later logons also sets it?
What is going on here?
Btw, I should mention that the logon trigger was initially an "after logon on database" and then it was corrected to "after logon on schema".
Not sure if that affects any of the above.
pl/sql developer Version 15.0.4.2064
Last edited:
