RE: Data encryption in Oracle 7.x

2001-05-22 Thread Christopher Spence

Must say, the DBMS_OBFUCSICATION_TOOLKIT is actually quite fast.  I would
highly agree with Jared's recommendation.

I have a few PL/SQL procedures I made that call this package to handle
encrypting passwords for logins and such and it works really well.


-Original Message-
Sent: Monday, May 21, 2001 11:22 PM
To: Multiple recipients of list ORACLE-L



Take a look at my article on encryption on Oracle.

It can be found at www.cybcon.com/~jkstill/util

It has some solutions ( such as RC4 ) that can
be implemented on Oracle 7.

There's also a Blowfish implementation there courtesy
of Craig Munday.

Keep one thing in mind:  encryption via PL/SQL is not very
fast.  Upgrade to Oracle 8 if possible and you will be much
better off, as you can then use DBMS_OBFUSCATION_TOOLKIT,
or other external encryption libraries.

Jared

On Monday 21 May 2001 14:22, 
[EMAIL PROTECTED] wrote:
 Hello fellow DBA's,

 I am in a tough situation. I am trying to find an encryption solution for
 Oracle 7.

 I know that 8i has DBMS_OBFUSCATION_TOOLKIT, however we don't have 8i :(

 We are still running 7.3.4 (OS limitations, DOS clients :(.

 Anyway, did any of you ever have to implement DES or one-way encryption in
 Oracle 7.x?
 Anyone of these solutions would help (the problem is that we would like to
 avoid encryption done in the application due to some limitations of the
 development environment).

 Thanks in advance for any help, links, directions...

 Val Gamerman.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  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: Christopher Spence
  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: Data encryption in Oracle 7.x

2001-05-21 Thread Jared Still


Take a look at my article on encryption on Oracle.

It can be found at www.cybcon.com/~jkstill/util

It has some solutions ( such as RC4 ) that can
be implemented on Oracle 7.

There's also a Blowfish implementation there courtesy
of Craig Munday.

Keep one thing in mind:  encryption via PL/SQL is not very
fast.  Upgrade to Oracle 8 if possible and you will be much
better off, as you can then use DBMS_OBFUSCATION_TOOLKIT,
or other external encryption libraries.

Jared

On Monday 21 May 2001 14:22, 
[EMAIL PROTECTED] wrote:
 Hello fellow DBA's,

 I am in a tough situation. I am trying to find an encryption solution for
 Oracle 7.

 I know that 8i has DBMS_OBFUSCATION_TOOLKIT, however we don't have 8i :(

 We are still running 7.3.4 (OS limitations, DOS clients :(.

 Anyway, did any of you ever have to implement DES or one-way encryption in
 Oracle 7.x?
 Anyone of these solutions would help (the problem is that we would like to
 avoid encryption done in the application due to some limitations of the
 development environment).

 Thanks in advance for any help, links, directions...

 Val Gamerman.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  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).