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

From: Suman S K <SumanK_at_mascotsystems.com>
Date: Wed, 16 Oct 2002 09:14:41 -0800
Message-ID: <F001.004EACA5.20021016091441@fatcity.com>

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

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). Received on Wed Oct 16 2002 - 12:14:41 CDT