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 <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/16/2002 10:14 AM
 Please respond to ORACLE-L

 
        To:     Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        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:[EMAIL PROTECTED]]
                 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 <[EMAIL PROTECTED]> 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 
[EMAIL PROTECTED] Before opening
attachments,
                                 please scan for viruses. 
 
 
                                 -- 
                                 Please see the official ORACLE-L FAQ: 
http://www.orafaq.com
                                 -- 
                                 Author: Suman S K
                                 INET: [EMAIL PROTECTED]
 
                                 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] Before opening attachments,
please scan for viruses. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suman S K
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to