Manage Passwords across multiple databases

Hi,

We have the same users connecting multiple database. A lot of them have differennt passwords but the same username. Whats the best way to have a system where the passwords across all the 3 databases are synced up.

Detail
-------

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

Below is a lousy way to accomplish it. Idea being - find a way to replicate the hash value across.


C:\Documents and Settings\Administrator>set ORACLE_SID=TEST
C:\Documents and Settings\Administrator>sqlplus "sys as sysdba"
SQL*Plus: Release 9.2.0.6.0 - Production on Fri May 20 17:02:02 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

SQL> create user axr2 identified by blah;
User created.

SQL> select password from dba_users where username='AXR2';
PASSWORD
------------------------------
75F58177277738EB

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
C:\Documents and Settings\Administrator>sqlplus system@PRODDB.APOLLOJR
SQL*Plus: Release 9.2.0.6.0 - Production on Fri May 20 17:02:58 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

SQL> alter user axr2 identified by values '75F58177277738EB';

User altered.

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

C:\Documents and Settings\Administrator>sqlplus axr2/blah@PRODDB.APOLLOJR
SQL*Plus: Release 9.2.0.6.0 - Production on Fri May 20 17:03:37 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
SQL>

How do we accomplish this from a stored procedure.

We are planning to provide a GUI environment to our users using plsql webtoolkit.

Thanks
Ron