RE: Data encryption in Oracle 7.x

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,
Val_Gamerman/Victoria_Financial.VICTORIA_FINANCIAL_at_lnn.com 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: jkstill_at_cybcon.com

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: 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  INET: cspence_at_FuelSpot.com

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