Print Thread
Multiple Connections Store with password [off] behavior
#42404 10/06/11 07:34 AM
Joined: Jul 2004
Posts: 24
Germany
H
herzig Offline OP
Member
OP Offline
Member
H
Joined: Jul 2004
Posts: 24
Germany
Hi,

what is the meaning of this option?
I don't want developers to be unaware of active connection so I never would recommend to use stored passwords. I even didn't try how it works switched to "on".
Now leaving it "off" should do what? I assume staying in same window, never asks again, which is normal, expected behavior to me. But using connection window, opening new windows etc. sometimes asks for password I already entered in active instance sometimes it doesn't.

I'm using ..1617 and ..1613, but also used "older" versions few days ago, so I can't tell exactly.

regards, jo

Re: Multiple Connections Store with password [off] behavior
herzig #42409 10/06/11 09:56 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
The password will not be stored, but as long as the connection is active you will not be prompted for the password again. If you explicitly log off the connection or restart PL/SQL Developer, you will be prompted for the password again.


Marco Kalter
Allround Automations
Re: Multiple Connections Store with password [off] behavior
Marco Kalter #42426 10/07/11 03:48 PM
Joined: Jul 2004
Posts: 24
Germany
H
herzig Offline OP
Member
OP Offline
Member
H
Joined: Jul 2004
Posts: 24
Germany
Ok, I hope I understand it right. Then this scenario doesn't look as designed:
(not sure if each step is necessary to reproduce, however..)

have "Allow mutliple connections" activated on PLSD ..1620
have "Store recent history" activated
have "Store with password" deactivted

(all connection changes/toggles below) are done via connection switch, recent history of the only one open sql window)

log off all, leaving one sql window open
log on DB A, enter pw
already open sql window is connected to main connection A
use sql window connection switch to change db connection to B
enter PW for connection B
run query, ok
use connection switch to go back to A
got message: Could not log on as [user]@ConnectionA, ORA-01005: No password..
click ok
get logon dialog for A again
enter PW,
connected
run query, ok
switch sql window back to B
no connection error this time for B
run query, ok
switch again to connection A
got message: Could not log on as [user]@ConnectionA, ORA-01005: No password.. again
reenter PW, run query, ok
switch sql window back to B
no connection error this time for B
...

You can repeat that probably endless. The original,main(!) connection gets never switched back without PW.
I didn't try with more than two connections.


regards
Re: Multiple Connections Store with password [off] behavior
herzig #42431 10/08/11 10:58 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
We'll check it out.


Marco Kalter
Allround Automations
Re: Multiple Connections Store with password [off] behavior
Marco Kalter #42438 10/10/11 07:44 PM
Joined: Mar 2007
Posts: 131
California, USA
Member
Offline
Member
Joined: Mar 2007
Posts: 131
California, USA
I have seen this behavior too. It was so annoying that I chose to launch different PLDs as before to use multiple connections.


~Sachin.

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.115s Queries: 14 (0.036s) Memory: 2.5153 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-03 23:36:48 UTC
Valid HTML 5 and Valid CSS