Re: Encrypting data before storing in columns

Hi

Use one way encryption as oracle does.
When the user enters passwd for the first time get its has value using dbms_utility.get_has_value and store it in the DB(number column). Whenever the user enter a password to logon use the dbms_utility.get... functio to get the hash value of the password entered and compare it with the one in the database. It is a lot safer the users querying the DB will always see a number and will have no clue of the password.

HTH
Arvind Balaraman
logo_palanisamy_at_my-deja.com wrote in message <8bu50h$4m7$1_at_nnrp1.deja.com>...
>Does Oracle have a way to encrypt data before storing it in varchar2
>table columns? Is there any better way than using a combination of
>replace, translate functions?
>
>What we want is to encrypt the application user password and store it
>in a not easy to decipher form.
>
>Thanks in advance.
>Logo Palanisamy
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Mar 30 2000 - 00:00:00 CST