Is it possible to export saved passwords from Toad

Joe Enos picture Joe Enos · May 28, 2010 · Viewed 56.9k times · Source

I'm looking for a way to export saved usernames/passwords from Toad for Oracle (9.5.0.31). It doesn't have to be in a usable format for importing - even a plaintext format would be fine.

I believe the passwords are stored encrypted in CONNECTIONPWDS.INI, but from what I've read, that file doesn't transfer from one machine to another. There doesn't seem to be anything in the Quest site or the Yahoo groups about this, other than "That's a very good suggestion...".

Has anyone had any luck accomplishing this? Or am I stuck with having to dig up the passwords for each of my accounts?

Thanks

Answer

Atilla Ozgur picture Atilla Ozgur · Jan 15, 2015

I did not find any way to export ALL connections but I can export one by one using the information from following link. Trick is to

  1. Create db link.
  2. Choose one of the existing connections
  3. Set user/pass to current
  4. Show sql

In the opened window, you can see your stored password. I successfully retrieved my stored password using this way.