Re: Encrypting data before storing in columns

In article <8bu4fc$41b$1_at_nnrp1.deja.com>, logo_palanisamy_at_my-deja.com wrote:
> 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,
> Logo Palanisamy
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

In 8.1.6 -- yes. before -- no.

see:

http://technet.oracle.com/doc/oracle8i_816/server.816/a76936/dbms_obf.ht m#6518

--
Thomas Kyte tkyte_at_us.oracle.com
Oracle Service Industries http://osi.oracle.com/~tkyte/index.html
--
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.