Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Encryption and Indexing

495123Sep 10 2007 — edited Sep 11 2007

My client deals with a great deal of personal data and must query by SSN in millions of records. The datatype is number and the column is indexed. There is also a function based index to add possible leading zeros. Neither index is unique.

TDE only protects from disk/backup theft and doesn't work with function based indexes.
Regular encryption can't use indexes.

Do all companies dealing in this type of data encrypt it?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 9 2007

Added on Sep 10 2007

#general-database-discussions

5 comments

563 views