Change database password

[Julie4435637]

Hello,

I connect to 5 databases and like to keep the password to all 5 the same. Last week I was locked out of one of the databases (because of excessive logon attempts ) and the administrator had to let me back in. The next time I went into the database - I was prompted to change my password. Now that database has a different password from the other 4 databases. I had just changed the other 4 database passwords recently - therefore I will not be prompted for another 60 days. How can I change the passwords without bothering the administrator?

 

[T-Gergely]

Good question: I miss the password command (or similar function) from PSD 7. You can change the password with alter user ... identified by ... command, but that may not be secure, the password might be eavesdropped.

 

[Hilarion]

There's also "Session" / "Change password..." option in PL/SQL Developer menu. It will change password for current session and store that password in that session connection definition.

 

[T-Gergely]

Thanks. It must have come later than version 7.