Password encryption.

[Arbe]

All,

I've got a field PASSWORD01 in my table TXEMPL.
I don't want people to be able to see the contents of this field when they do a select or look at the data via TOAD. Do I need to give a special datatype for this field when I create the table, or is there another way to encrypt this field?

Thx,

Rik

[JChiappa]

It depends : Oracle databases do NOT have a special encrypted field, but in the last releases of 8i you get dbms_obfuscation, a built-in package to scramble sensitive-data in the database - to only hide values from end-users in the office, it is quite OK, check the docs to more info about it.
But, if you want to keep extra-important data, like credit-card numbers, or the data will be acessible to many people (in Internet, maybe) you will need a strong package (with 128 bits, triple DESA, and related strong encript). A good package to do it is PGP, check it on the net.

[]s
Chiappa