RE: changing password

From: Gregory Conron <gconron_at_hfx.andara.com>
Date: Thu, 28 Dec 2000 17:56:15 -0400
Message-Id: <10724.125413@fatcity.com>

On Thu, 28 Dec 2000, you wrote:
> and now for the other baffler ...
> user abc originally identified by something ... password unkown to dba but i
> have the encrypted value from dba_users' table ...
> i changed the id password temporarily ... now i need to change it back to
> its original value ... can this be done?

Yep - alter user username identified by values 'ENCRYPTED_VALUE'; where encrypted_value is the encrypted password you have from dba_users.

Cheers,
GC

-- 
"The opposite of a correct statement is a false statement. But the opposite 
of a profound truth may well be another profound truth." 
                                    --Niels Bohr

Received on Thu Dec 28 2000 - 15:56:15 CST