How to save passwords in PL/SQL Developer?

Question

I've put my database info into Tnsnames.ora, and now each time I start PL/SQL Developer I get a dropdown list of my databases, but I have to type in the password every time.

There is an option under Tools>Preferences to store passwords for multiple connections, but it doesn't seem to have any effect. The password field is always blank when I start the application.

How can I get this to remember the password?

I'm using PL/SQL Developer 9.0.2.1621

score 26 · Answer 1 · answered May 12 '13 at 19:04

26

Goto:- Tools-->Preferences-->Logon History--> click the check box store with history & store with password.-->Apply.

answered May 12 '13 at 19:04

Ajit

261
3
2

Perfect, works like a charm ! For version above 12.X.X, it's Configure -> Preferences -> Logon History – Maulik Kayastha Aug 03 '22 at 09:15

score 8 · Accepted Answer · answered Apr 12 '12 at 09:24

8

After you login for the first time, password is saved. Next time, no need to type, click on the [...] next to the UserName and select database, it will autologon. Hope it helps!

answered Apr 12 '12 at 09:24

Narain

872
9
11

1

I tried this, and can switch between different saved usernames, but it is not saving the password. – axiomx11 Apr 12 '12 at 19:44
12

My version is 8.0.1. I have it like Tools -> Preferences -> LogOnHistory -> CheckBox called Store with Passoword. [I also have store history enabled] – Narain Apr 13 '12 at 08:18

score 2 · Answer 3 · answered Dec 16 '19 at 17:02

2

It's 2019 and sqldeveloper is at version 19.2.

In case anyone, as I did, stumbles on this old but still actual question, the answer has become:

right-click on the relevant connection in the left menu and choose Properties
type in the pwd in the relevant input and check "Save Password"
click on Save button
confirm that you want to overwrite the previous description

answered Dec 16 '19 at 17:02

Marco Faustinelli

3,734
5
30
49

6

For some reason, not working for me - I checked save password, tested connection, clicked connect and it still prompted for password – JGlass Jan 13 '20 at 19:29

score 1 · Answer 4 · answered Jun 25 '20 at 11:43

1

i found the same issue with 19.1....

go to connection properties, check the box to save password. enter the password and click save. close the properties box.

now click save all.

this worked for me.

answered Jun 25 '20 at 11:43

user2983931

304
5
17

How to save passwords in PL/SQL Developer?

4 Answers4