Oracle password change.

[jayjaybigs]

Hi All,

We are just implementing new applications for our billing group. I have been tasked to come up with a script that will periodically change the password for all the applications connecting to the database.

I was wondering if you have any site/scripts that will periodically change the passwords for all the application concections.

This password should go accross all the servers and change each application's connection to the database.

Thanks a lot

Jayjay

 

[Beilstwh]

How are you planning on letting the users know what their new password are? A much better way might be to use a profile and have the passwords expire after a set amount of time. This way the user would be forced to change the password before they could continue and only the user of the application would know the new password. You could also add password validation to enforce your own password rules.

Bill
Oracle DBA/Developer
New York State, USA