Re: encryption of strings

Do you have an example of this code? I would be curious to see it.

Thanks

Michael.

Connor McDonald wrote:

> Clinique wrote:
> >
> > Hi everybody,
> > I am searching for a possibility to encrypt string data types which serve as
> > passwords in a database table for user management.
> > Does Oracle offer some kind of procedure for encryption?
> > Susanne
>
> Have a look at Thomas's solution...If you require DE-cryption as well as
> encryption, you can try the following:
>
> Have a (secret) key of (say) 30 chars
> For each char in string
> - get ascii val of char
> - get ascii val of i'th char in key
> - exclusive-or the two values
> - chr() the resultant value - this is the 'encrypted' char
>
> The resultant encryted string is relatively difficuly to break. To
> decrypt, just run encyrption again.
>
> HTH
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk
>
> We are born naked, wet and hungry...then things get worse
Received on Tue Jun 13 2000 - 00:00:00 CDT