ThatJeffSmith

Password Resets No Longer Require a Thick Connection (Oracle Client) in SQL Developer

Tell Others About This Story:

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.

No more!

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.

Nothing configured on the Client (THICK) side.

Nothing configured on the Client (THICK) side.

Now right-click on your connection where you want to reset the password (for the user defined in that connection):

Yup, this one.

Yup, this one.

Put in the old and new passwords.

If it works, the dialog will just close on OK - if it doesn't, you'll see an error message.

If it works, the dialog will just close on OK – if it doesn’t, you’ll see an error message.

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

We ship with 12.2 driver in 4.2 EA2.

We ship with 12.2 driver in 4.2 EA2.

Related Posts Plugin for WordPress, Blogger...
Tell Others About This Story:

Similar Posts by Content Area: , ,