SQL Developer password decryptor
Description
A simple script to decrypt stored passwords from the Oracle SQL Developer IDE.
Features
- Support old (v3, v4->v19.1) and new (from v19.2) password encryption
- Comes in 2 flavors: a Jython and a Python script
Prerequisites
Passwords
Version 3 until version 18.1
Passwords are stored encrypted in the connections.xml file in those locations:
- Windows:
%APPDATA%\SQL Developer\system<VERSION>\o.jdeveloper.db.connection.<VERSION>\connections.xml - Linux:
~/.sqldeveloper/system<VERSION>/o.jdeveloper.db.connection.<VERSION>/connections.xml
Version 18.3 and newer
Passwords are stored encrypted in the connections.json file in those locations:
- Windows:
%APPDATA%\SQL Developer\system<VERSION>\o.jdeveloper.db.connection\connections.json - Linux:
~/.sqldeveloper/system<VERSION>/o.jdeveloper.db.connection/connections.json
Installation ID
Passwords are stored encrypted in the aforementioned connections.xml and connections.json file but the encryption key by default uses an installation-unique random UUID value db.system.id in the product-preferences file.
Version 3 until version 18.1
- Windows:
%APPDATA%\SQL Developer\system<VERSION>\o.sqldeveloper.<VERSION>\product-preferences.xml - Linux:
~/.sqldeveloper/system<VERSION>/o.sqldeveloper.<VERSION>/product-preferences.xml
Version 18.3 and newer
- Windows:
%APPDATA%\SQL Developer\system<VERSION>\o.sqldeveloper\product-preferences.xml - Linux:
~/.sqldeveloper/system<VERSION>/o.sqldeveloper/product-preferences.xml
When exporting one or more connections from version 4, the user is asked to type a password: that password is then used as a key to encrypt the entries instead of the db.system.id value.
Options
$ python sqldeveloperpassworddecryptor.py -h
Usage: sqldeveloperpassworddecryptor.py [options]
Version: 2.1
Options:
-h, --help show this help message and exit
Main parameters:
-p ENCRYPTED_PASSWORD, --encrypted-password=ENCRYPTED_PASSWORD
(mandatory): password that you want to decrypt. Ex. -p
054D4844D8549C0DB78EE1A98FE4E085B8A484D20A81F7DCF8
-d DB_SYSTEM_ID_VALUE, --db-system-id-value=DB_SYSTEM_ID_VALUE
(mandatory from v4): installation-unique value of
"db.system.id" attribute in the "product-
preferences.xml" file, or the export file encryption
key. Ex: -d 6b2f64b2-e83e-49a5-9abf-cb2cd7e3a9ee
-o, --old (mandatory between v4 and v19.1) if the password you
want to decrypt is for a product version between 4 and
19.1
Examples
v3 password
$ jython sqldeveloperpassworddecryptor.jy -p 054D4844D8549C0DB78EE1A98FE4E085B8A484D20A81F7DCF8
[+] encrypted password: 054D4844D8549C0DB78EE1A98FE4E085B8A484D20A81F7DCF8
[+] decrypted password: password
v4 -> v19.1 password
$ python sqldeveloperpassworddecryptor.py -d 6b2f64b2-e83e-49a5-9abf-cb2cd7e3a9ee -p Shz0tQgqkuAfLy65s21gTVD7wacDYwG6 -o
sqldeveloperpassworddecryptor.py version 2.1
[+] encrypted password: Shz0tQgqkuAfLy65s21gTVD7wacDYwG6
[+] db.system.id value: 6b2f64b2-e83e-49a5-9abf-cb2cd7e3a9ee
[+] decrypted password: s4gswagswaag!5465636MP
from v19.2 password
$ python sqldeveloperpassworddecryptor.py -d 7d97189a-4e22-4061-bc07-35b9d2b39f3c -p "LUA63VW21TqaHNJSvKF6DI8zv1/dvXzBhyMPVN8lAws="
sqldeveloperpassworddecryptor.py version 2.1
[+] encrypted password: LUA63VW21TqaHNJSvKF6DI8zv1/dvXzBhyMPVN8lAws=
[+] db.system.id value: 7d97189a-4e22-4061-bc07-35b9d2b39f3c
[+] decrypted password: password1
Dependencies and installation
- For the
Jythonversion: well, only Jython (apt-get install jythonor download it here) - For the
Pythonversion:- The easiest way to setup everything:
pip install sqldeveloperpassworddecryptorand then directly use$ sqldeveloperpassworddecryptor - Or manually install PyCryptodome:
pip install pycryptodomex
- The easiest way to setup everything:
Changelog
- version 2.1 - 08/11/2021: new encryption type support (from v19.2)
- version 2.0 - 11/11/2020: Python 3 support
- version 1.2 - 07/14/2017: replacing PyCrypto by PyCryptodomex for these reasons
- version 1.1 - 05/30/2017: shebang addition
- version 1.0 - 07/23/2014: Initial commit
Copyright and license
sqldeveloperpassworddecryptor is free software: you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
sqldeveloperpassworddecryptor is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the GNU Lesser General Public License for more details.
You should have received a copy of the GNU Lesser General Public License along with sqldeveloperpassworddecryptor. If not, see http://www.gnu.org/licenses/.
Greetings
- ajokela for its Java snippet for v3
- AlessandroZ for its Python snippet for v4
Contact
- Thomas Debize < tdebize at mail d0t com >
Metadata
Release files for sqldeveloperpassworddecryptor 2.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| sqldeveloperpassworddecryptor-2.1.tar.gz | 6.7 kB | Without provenance | Details for sqldeveloperpassworddecryptor-2.1.tar.gz |
Release files / sqldeveloperpassworddecryptor-2.1.tar.gz
| Download URL | sqldeveloperpassworddecryptor-2.1.tar.gz |
|---|---|
| Size | 6.7 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
5b84b1d856f0b7c3e5cbddd263e9aca25006685a3ac7b3c65b71fdbc39d98745
|
|
BLAKE2b-256 checksum How to use checksums |
cafe9211e75399f12278b7e7fb667d1d0660b3a65720b9ae0307a49ec115d7d1
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.3.0 pkginfo/1.4.2 requests/2.25.1 setuptools/52.0.0 requests-toolbelt/0.9.1 tqdm/4.57.0 CPython/3.9.2
|
Security for sqldeveloperpassworddecryptor 2.1
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.