I guess I forgot to mention that the two databases are on two different OS.
One is OpenVMS and other Win2000.
The HEX approach will not work.
"Anna C. Dent" <anacdent_at_hotmail.com> wrote in message news:<D9hqb.9323$L77.2049_at_fed1read03>...
> Lasher wrote:
> > 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.........
>
> Alternatively, you could simple grab the hashed HEX password value
> & jam it into the other instance.
>
> This is a variation on how a DBA can "break into" any schema in the DB.
> 1) Save away the HEX hashed password.
> 2) ALTER USER IDENTIFIED BY dba;
> 3) Do what needs to be done.
> 4) Restore the original password.
Received on Thu Nov 06 2003 - 07:43:23 CST
