Re: capture oracle pwd change in 3rd party application. help needed

One way to sync a users password between database A and database B would be (Assuming username xxx):

In A:

       select password from dba_users where username = 'xxx';

      will return you a hash value which would look something like this:
      '4324C304B9H9G000'

In B:
     alter user xxx identified by values '4324C304B9H9G000';

Note the following:

• The use of "values" keyword in alter user .. using which you can set a users hashed password value. * I'm assuming same database versions of A and B. * You can only sync password for the same username this way. Setting user yyy's hashed password to be like xxx's hashed password will not make their actual passwords to be the same.

... I'm assuming you can work out rest of the details.

Anurag

"Lasher" <hgrabowy_at_hotmail.com> wrote in message news:801f14b4.0311051134.938df83_at_posting.google.com...
> Hi,
>
> I have clients using an application that allows users to change their
> passwords. The application uses the 'ALTER USER xxx IDENTIFIED
> BY.....' command. What I need to do is use Oracle to capture the
> username and password and send the info to another Oracle instance on
> a different server and update that users password.
>
> Basically I need to keep the user's password in sync between two
> different databases.
>
> I also cannot change the application in anyway and therefore need to
> do this from the Oracle side.
>
> Any ideas would be great.........
Received on Wed Nov 05 2003 - 18:33:51 CST