Oracle-L: RE: How to configure MD5 data encription in Oracle 8i

From: <Jared.Still_at_radisys.com>
Date: Wed, 16 Oct 2002 10:46:44 -0800
Message-ID: <F001.004EAFD0.20021016104644@fatcity.com>

Try DBMS_OBFUSCATION_TOOLKIT.

See http://www.cybcon.com/~jkstill/util/encryption/encryption.html for an article on its use, and code samples.

Jared

Suman S K <SumanK_at_mascotsystems.com>
Sent by: root_at_fatcity.com
10/16/2002 10:14 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: How to configure MD5 data encription in Oracle 8i

I want to do it other way, generate the password in Database. Send the generated password to user and encrypt and store in table. Next time user will log in password will be encrypted on client side only and validated with database table.
I heard MD5 hashing is supported by Oracle 8I but I don't know how to configure.

Thanks
Suman

                 Shailendra Kr. Suman
                 Mascot System Limited
                 No.1, Main Road, Jakkasandra
                 Off Sarjapur Road
                 Koramangala Extn
                 Bangalore - 560034 
                 Tel: 91-80-5521701/5521706 Ext-2065
                 Mobile: 9845045895
                 -----------------------------------------------------


                 -----Original Message-----
                 From:           ora ak [SMTP:ora_magic_at_yahoo.com]
                 Sent:           Wednesday, October 16, 2002 9:40 PM
                 To:             Multiple recipients of list ORACLE-L
                 Subject:                Re: How to configure MD5 data

encription in Oracle
8i

                 why not use encryption outside the database and store

encrypted
string in database . We do it all the time , java application does the encrytion and authentication , db just stores the encrypted string .

                 Just an idea . 

                 I dont the answer of your original question :) 

                 Oramagic 

                  Suman S K <SumanK_at_mascotsystems.com> wrote: 

                                 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_at_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_at_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_at_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).

                 Do you Yahoo!?
                 Faith Hill <http://faith.yahoo.com>  - Exclusive Performances,
Videos, & more
                 faith.yahoo.com <http://faith.yahoo.com>

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_at_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_at_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_at_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:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------