Message-ID: <F001.004EA5E5.20021016055858@fatcity.com>
Date: Wed, 16 Oct 2002 05:58:58 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Tim Gorman" <Tim@SageLogix.com>
Subject: Re: How to configure MD5 data encription in Oracle 8i
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Procedures and functions to create MD5 hashes (from RAW or VARCHAR2 inputs)
are available (undocumented) in the DBMS_OBFUSCATION_TOOLKIT package.  Check
online doc at "$ORACLE_HOME/rdbms/admin/dbmsobtk.sql" for what little usage
info there is...

----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L@fatcity.com>
Sent: Wednesday, October 16, 2002 6:48 AM


> Hi Everybody,
>
>
> Can anyone tell me how to use MD5 hashing algorithm in Oracle8I
> Or is there any built in package to encrypt the data in Oracle 8i.
>
> I have created the Application user table there I am keeping user_Id
> and Password
> for the application. How to hide the password column in the table ?
>
> Thanks
> Suman
>
>
>
>
>
>
>
>
>
> DISCLAIMER: Information contained and transmitted by this E-MAIL is
> proprietary to Mascot Systems Limited and is intended for use only by the
> individual or entity to which it is addressed, and may contain information
> that is privileged, confidential or exempt from disclosure under
applicable
> law. If this is a forwarded message, the content of this E-MAIL may not
have
> been sent with the authority of the Company. If you are not the intended
> recipient, an agent of the intended recipient or a person responsible for
> delivering the information to the named recipient, you are notified that
any
> use, distribution, transmission, printing, copying or dissemination of
this
> information in any way or in any manner is strictly prohibited. If you
have
> received this communication in error, please delete this mail & notify us
> immediately at Mailadmin@mascotsystems.com Before opening attachments,
> please scan for viruses.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Suman S K
>   INET: SumanK@mascotsystems.com
>
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California        -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: Tim@SageLogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).