Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to save passwords in PL/SQL Developer?

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

like image 664
axiomx11 Avatar asked Apr 10 '12 21:04

axiomx11


People also ask

How do I save a username and password in PL SQL Developer?

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.

Where does SQL Developer save passwords?

Go to the File menu and click on the newly added, "Show Me Password" option to view all your saved connections and passwords.


3 Answers

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

like image 146
Ajit Avatar answered Oct 19 '22 08:10

Ajit


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!

like image 22
Narain Avatar answered Oct 19 '22 07:10

Narain


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
like image 2
Marco Faustinelli Avatar answered Oct 19 '22 08:10

Marco Faustinelli