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