Re: Help !! Password Encryption/decryption ??
Thanx everybody .
Jp.
"Aponte, Tony" wrote:
How about right-padding the string to a multiple of 8
bytes. I think 8-MOD(LENGTH(string),8) will give you the number of
characters to use in RPAD(string,...). E.I.. to pad with blanks:
SELECT RPAD('123456789',LENGTH('123456789') + 8 - MOD(LENGTH('123456789'),8),'
') AS "12345678901234567890" FROM DUAL
1234567890123456
123456789
HTH
Tony Aponte
-Original Message-
From: Prem J Khanna [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L
Subject: Help !! Password Encryption/decryption ??
Hello everybody ,
I am on 8.1.6/NT .
i need to encrypt / decrypt the password of my users for
my web based
application.
I went thro' DBMS_OBFUSCATION_TOOLKIT.DESEncrypt and
DBMS_OBFUSCATION_TOOLKIT.DESDecrypt methods .
but as per the docs , this package requires the
password ( which is to
be encrypted ) to be
in multiples of 8 bytes . i don't think this is
possible always .
have i understood anything wrong ? can anyone
throw some light on this
.
how do u guys encounter this situation ? any likely scripts
plz ?!!!
TIA.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Prem J Khanna
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051
FAX: (858) 538-5051
San Diego, California
-- Public Internet access / Mailing Lists
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).
RE: Help !! Password Encryption/decryption ??
Title: RE: Help !! Password Encryption/decryption ??
How about right-padding the string to a multiple of 8 bytes. I think 8-MOD(LENGTH(string),8) will give you the number of characters to use in RPAD(string,...). E.I.. to pad with blanks:
SELECT RPAD('123456789',LENGTH('123456789') + 8 - MOD(LENGTH('123456789'),8),' ') AS "12345678901234567890" FROM DUAL
1234567890123456
123456789
HTH
Tony Aponte
-Original Message-
From: Prem J Khanna [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L
Subject: Help !! Password Encryption/decryption ??
Hello everybody ,
I am on 8.1.6/NT .
i need to encrypt / decrypt the password of my users for my web based
application.
I went thro' DBMS_OBFUSCATION_TOOLKIT.DESEncrypt and
DBMS_OBFUSCATION_TOOLKIT.DESDecrypt methods .
but as per the docs , this package requires the password ( which is to
be encrypted ) to be
in multiples of 8 bytes . i don't think this is possible always .
have i understood anything wrong ? can anyone throw some light on this
.
how do u guys encounter this situation ? any likely scripts plz ?!!!
TIA.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Prem J Khanna
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
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).
RE: Help !! Password Encryption/decryption ??
We use it and we have created all the encrypted fields with a length as a multiple of 8 bytes. Then pad the data to the next multiple of 8 bytes before storing. Then trim it after retrieving the data and decrypting it. HTH, Beth -Original Message- Sent: Friday, February 08, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Hello everybody , I am on 8.1.6/NT . i need to encrypt / decrypt the password of my users for my web based application. I went thro' DBMS_OBFUSCATION_TOOLKIT.DESEncrypt and DBMS_OBFUSCATION_TOOLKIT.DESDecrypt methods . but as per the docs , this package requires the password ( which is to be encrypted ) to be in multiples of 8 bytes . i don't think this is possible always . have i understood anything wrong ? can anyone throw some light on this . how do u guys encounter this situation ? any likely scripts plz ?!!! TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prem J Khanna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Help !! Password Encryption/decryption ??
- Original Message - > I went thro' DBMS_OBFUSCATION_TOOLKIT.DESEncrypt and > DBMS_OBFUSCATION_TOOLKIT.DESDecrypt methods . > but as per the docs , this package requires the password ( which is to > be encrypted ) to be > in multiples of 8 bytes . i don't think this is possible always . > yes, this is implied by the fact that DES works with blocks take a look at http://www.cybcon.com/~jkstill/util/encryption/encryption.html for an overview of alternative ways for encryption/obfuscation hth, Marin "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. " -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Help !! Password Encryption/decryption ??
You could get creative by using RPAD() or LPAD() ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, February 08, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Hello everybody , I am on 8.1.6/NT . i need to encrypt / decrypt the password of my users for my web based application. I went thro' DBMS_OBFUSCATION_TOOLKIT.DESEncrypt and DBMS_OBFUSCATION_TOOLKIT.DESDecrypt methods . but as per the docs , this package requires the password ( which is to be encrypted ) to be in multiples of 8 bytes . i don't think this is possible always . have i understood anything wrong ? can anyone throw some light on this . how do u guys encounter this situation ? any likely scripts plz ?!!! TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prem J Khanna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
RE: Help !! Password Encryption/decryption ??
Title: RE: Help !! Password Encryption/decryption ??
Here it is for any length.
SELECT RPAD('&thestring',LENGTH('&thestring') + 8 - DECODE(MOD(length('&thestring'),8),0,8,MOD(length('&thestring'),8)),' ') ||'<' AS "12345678901234567890" FROM DUAL
Tony Aponte
-Original Message-
From: Aponte, Tony
Sent: Friday, February 08, 2002 11:32 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Help !! Password Encryption/decryption ??
How about right-padding the string to a multiple of 8 bytes. I think 8-MOD(LENGTH(string),8) will give you the number of characters to use in RPAD(string,...). E.I.. to pad with blanks:
SELECT RPAD('123456789',LENGTH('123456789') + 8 - mod(length('12345678'),8),' ') AS "12345678901234567890" FROM DUAL
1234567890123456
123456789
HTH
Tony Aponte
-Original Message-
From: Prem J Khanna [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L
Subject: Help !! Password Encryption/decryption ??
Hello everybody ,
I am on 8.1.6/NT .
i need to encrypt / decrypt the password of my users for my web based
application.
I went thro' DBMS_OBFUSCATION_TOOLKIT.DESEncrypt and
DBMS_OBFUSCATION_TOOLKIT.DESDecrypt methods .
but as per the docs , this package requires the password ( which is to
be encrypted ) to be
in multiples of 8 bytes . i don't think this is possible always .
have i understood anything wrong ? can anyone throw some light on this
.
how do u guys encounter this situation ? any likely scripts plz ?!!!
TIA.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Prem J Khanna
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
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).
Re: Help !! Password Encryption/decryption ??
See the encryption article at www.cybcon.com/~jkstill Jared Prem J Khanna <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/08/02 06:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Help !! Password Encryption/decryption ?? Hello everybody , I am on 8.1.6/NT . i need to encrypt / decrypt the password of my users for my web based application. I went thro' DBMS_OBFUSCATION_TOOLKIT.DESEncrypt and DBMS_OBFUSCATION_TOOLKIT.DESDecrypt methods . but as per the docs , this package requires the password ( which is to be encrypted ) to be in multiples of 8 bytes . i don't think this is possible always . have i understood anything wrong ? can anyone throw some light on this . how do u guys encounter this situation ? any likely scripts plz ?!!! TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
