Database User Password Reset Procedure
For security purposes the database user password are set to expire every 90 days, hence its user’s responsibility to reset it.
When password is about to expire the DB client (sql developer,Toad, etc…) used to log in the database will pop-up to warn the user.
Is required to follow the next steps to reset the passwords before expires to avoid lost access:
Right click on the connection setup – choose “Reset Password” option as shown
It will bring popup to reset by entering existing and new password.
The password should be complex enough to pass below requirements:Password should be different from previous password, at least 4 characters.
Should have 9 characters
o 2 upper case
o 2 lower case
o 2 digits
o 2 specials
Once the Password is reset, it will be required the next log in on the database
NOTE: If the reset password option is greyed out please update your SQL Developer to the latest version going to Help >Check for Updates…
And Update the Oracle SQL Developer and Oracle Extensions
If still the option is not available please inform to SaaS Support