Oracle encryption questions
Hi Everyone,
I have several questions related to implementation of advanced security - encryption.
1. after encrypting an indexed column with: alter table tablename modify column encrypt no salt; I had to reverse the encryption:
alter table tablename modify column decrypt;
the current index on the column is different from the original index. What is the impact on the effectiveness of the index? how to make the index to be the same as before?
2. For a compound index consisting of three columns, when I encrypt all three columns using:
alter table tablename modify column1 encrypt no salt;
alter table tablename modify column2 encrypt no salt;
I have several questions related to implementation of advanced security - encryption.
1. after encrypting an indexed column with: alter table tablename modify column encrypt no salt; I had to reverse the encryption:
alter table tablename modify column decrypt;
the current index on the column is different from the original index. What is the impact on the effectiveness of the index? how to make the index to be the same as before?
2. For a compound index consisting of three columns, when I encrypt all three columns using:
alter table tablename modify column1 encrypt no salt;
alter table tablename modify column2 encrypt no salt;
0