Re: [Help]: Looking for password crypt/decrypt function

And this gives excellent encryption if you use a pseudo-random sequence of binary codes to XOR with your data.

Most 'random' functions generate an un-predictable sequence of values. However, the sequence is repeatable! You just have to start with the same seed value. That means the seed value is your encryption key!

Connor McDonald wrote:

> damita wrote:
> >
> >
> >
> > If youre just trying to encrypt user defined (not oracle login passwds)
> > passwords
> > try some form of: TRANSLATE(str,from,to)
> >
> > use same function (in reverse offcourse) to decrypt passwd.
> >
> > this mebbe too simple for you application, mebbe your needs call for a more
> > complex algorithm.
> >
> > cheers
> > --
> > Damita Wijay db-eh?
> > Magardi Inc
> > Ottawa Canada
> >
> > ngreene_at_my-dejanews.com wrote:
> >
> > > Does anyone have a password crypt/decrypt function that can be used like the
> > > one in mySQL? I need to store encrypted passwords in an Oracle database and
> > > need a way to decrypt them as well.
> > >
>
> One easy way is:
>
> a. change each char in the string to ascii
> b. convert the ascii to a string of 8-bit binary
> c. exclusive-or the binary with a preknown binary key
> d. convert the result back to ascii
> e. convert the ascii back to text
>
> The nice thing with this algorithm is that the encrypt and decrypt
> functions are the same...ie, re-encrypt the encrypted code to decrypt
> it...
>
> Cheers
>
> --
> ==============================================
> Connor McDonald
> BHP Information Technology
> Perth, Western Australia
> "Never wrestle a pig - you both get dirty and the pig likes it..."
Received on Tue Apr 13 1999 - 09:30:29 CDT