Re: Oracle Password Encryption Algorithm

From: g.r.s. deisz <g.r.s.deisz_at_ptt-telecom.unisource.nl>
Date: 1997/03/19
Message-ID: <5go5j2$1uv@pwxl01.telecom.ptt.nl>#1/1

dave_at_fifthd.ca (Dave Macpherson) wrote:

>Does anyone know the algorithm used to encrypt an Oracle password? I
>need to verify that a password entered in by a user matches an
>encrypted password stored in DBA_USERS.

After you updates the password, you could check in DBA_USERS if the encrypted version matches any other password. If it does, you can force the user to change it.

Stefan.

Name      :G.R.S. Deisz
Phone     :+31-50-5855954
E mail    :G.R.S.Deisz_at_PTT-Telecom.Unisource.NL
DISCLAIMER:This statement is not an official statement from, nor
           does it represent an official position of, PTT Telecom BV.

Received on Wed Mar 19 1997 - 00:00:00 CST