My company has decided to change the database passwords each quarter. We are using an Oracle 10 db.

Currently, when the password is changed, I have to open each individual crystal reports report file (.rpt) in the CR developer program and save each report to using the new DB password.

I then have to upload each of these reports to the specific folder on the CR server, then go into the CMC, to the Process>Database tab and change the database password in there as well.

With over 50 reports, this process takes several hours to complete. Is there a better way to change the password so the process is less time consuming?

Thanks