Re: encryption of strings

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