Syncing passwords across multiple databases

Hi,

We have 3 databases

A, B and C and the emplyees of our company have accounts in all of them. We plan to write a front end so that they can manage the passwrds themselves rather than letting the DBA do that.

That is they will have a User Interface where they can modify the password and that will update the password in all the 3 instances. This will ensure that the passwords are always same cross different applications accessing different databases.

Its easy to write a procedure which can do this to a database where the password management application resides. How does one go about updating the user passwords in the remore database using stored procedure.

Thanks
Ron Received on Fri May 20 2005 - 14:46:55 CDT