Hello,

We work for an organization where there are rules for security reasons that we should change database passwords every 30 days. We run about 15 sites, where all the web applications connect to those databases using datasources(with the userid/password information). The question is to automate this entire process(changing password every 30 days on the database AND dynamically set the new password to the new datasource, and switch from the old datasource to the new datasource, all in a single thread, with no downtime of sites. This would include switching the open connections that point to the old datasource to the new datasource). we use ATG Dynamo 5.1.1_p5 for the App Server and Sybase as our Database. Have anyone dealt with this kind of problem before? Please let me know your thoughts.

Thanks
Shital