-
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
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|