Stephane Faroult who posts regularly to the Oracle-l mailing list emailed me earlier in the week to let me know about a free Java tool written by Noel Talard. A thread on Oracle-l titled "password and dblink mgmt tool
" asked if anyone has a tool to manage database schema passwords and database link passwords. This is because for Sarbanes Oxley all apps passwords have to be rotated every six months at least. The poster also said that any copied database to test or dev also needs passwords to be rotated. Stephane posted a nice small Java tool written by Noel Talard to the original thread author that can be used for this purpose.
Stephane and Noel thought that this tool would be useful for many other people so they kindly agreed to let me host it on my Oracle Security Tools page
in the free tools section. It is called ChgPwd
The tool performs a number of basic checks (at least 6 characters, at least one digit, different from username, different from previous password). I have not had chance to test the tool myself yet but it is there if anyone would like it.