Re: Does Oracle Support MD5()

From: Geoff Muldoon <gmuldoon_at_nospam.scu.edu.au>
Date: Wed, 11 May 2005 09:30:26 +1000
Message-ID: <MPG.1cebef1e97ce01a59896b0@news.x-privat.org>

postbus_at_sybrandb.demon.nl says...
> On Wed, 11 May 2005 01:18:51 +0800, "ashley" <none_at_gmeail.com> wrote:
>
> >A username/password table. Both we dont want to keep password in plaintext.
> >So it is better to keep the hashed (MD5) image. If you have used Tomcat web
> >server, the JDBCRealm requires such a table with password MD5'ed.
>
> As to your question, there is a dbms_obfuscation package in Oracle
> which allows you to encrypt any string.

By any number of encryption methods including MD5.

Specifically (after defining variables v_not_hashed and v_hashed): v_hashed := DBMS_OBFUSCATION_TOOLKIT.MD5(input_string => v_not_hashed);

Geoff M Received on Tue May 10 2005 - 18:30:26 CDT