Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

change connection password for dozens of connections

meravkeApr 21 2024

Hi,

I have the same user with the same password in dozens of different instances. Every 3 months I have to change password . While I run a script that changes the password of my user in all instances, I also need to change its in SQL Developer ( version 21).

in older versions , when Export Connections was saved into xml file, I was able to change the encripted password for all connections (with a simple replace all in an editor) . Now, when Export Connections is exporting into JSON file, I am now able to do so. Even though my user's password is the same for all my connections (same user in different DBs), the encrypted password looks different, so using replace is not an option an more. So I going manually over all my 100+ connections, one by one, and manually change password, which is very frustrating.

Is there an easy way to massively change passwords in SQL Developer connections?

This post has been answered by thatJeffSmith-Oracle on Apr 22 2024
Jump to Answer
Comments
Post Details
Added on Apr 21 2024
4 comments
524 views