Oracle SQL Developer Password Storage

I have forgotten my password to one of our Oracle database server due to “change password every three months” policy. Luckily I have it stored in my Oracle SQL Developer application. I know the password will be stored in a encrypted format but since it must be sent in plain text to server I’m sure the encryption is reversible.

Google it giving me a few interesting result. The first is a Oracle SQL Developer extension to reveal password (https://code.google.com/p/show-me-password-sql-developer/). I’ve installed it but somehow it’s not always working. The extension option is not always available in right-click menu, and also it does not show all the stored passwords.

Another result points me to a gist (https://gist.github.com/ajokela/1846191), which has the code to decrypt the password.

Below code is copied from the gist, credit belongs to its original author.

Leave a Reply

Your email address will not be published. Required fields are marked *