Thanks to an update in a 12c JDBC driver for Oracle Database, we can now update a password natively, without being connected to the database.
Previous to version 4.2 EA2 – users would either have to be connected already OR have an Oracle Client available.
A post I did up explaining this is one of the most read articles on this site – you can imagine how many users out there have expired passwords and need help resetting said passwords.
Well, previous to this update, it would require their desktop admins to not only put down SQL Developer, they’d also need to put down a compatible Oracle Client. And SQL Developer would have to be configured. Or of course, the user could email their DBA for help.
So, So Easy Now
JUST install version 4.2 (GA when released or Early Adopter 2 for now), and right-click on your connection. That’s it.
Now right-click on your connection where you want to reset the password (for the user defined in that connection):
Put in the old and new passwords.
TIP: When you do this, we update the password string for your connection properties for you, automatically. So no need to go update the password on your connection after you change the password in the database. This is assuming of course, that you choose to save your passwords.
Curious to what JDBC driver your connection is actually using?
SHOW JDBC– run with F5