Thanks for the question, vinesh.
Asked: April 12, 2017 - 2:41 pm UTC
Last updated: April 14, 2017 - 10:02 am UTC
Version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
Viewed 1000+ times
You Asked
Team,
As part of my request please consider the below create and insert statements :
Version of DB being used is : Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
create table bo_master(ssn number, bo_code number,phone_number number, email_id varchar2(25));
insert into bo_master values (970169000,7001,1234567890,'john@gmail.com');
insert into bo_master values (970169001,7002,1234567891,'tim@gmail.com');
insert into bo_master values (970169002,7003,1234567892,'baker@gmail.com');
insert into bo_master values (970169003,7004,1234567893,'smith@gmail.com');
insert into bo_master values (970169004,7005,1234567894,'jamesohn@gmail.com');
insert into bo_master values (970169005,7006,1234567895,'alice@gmail.com');
insert into bo_master values (970169006,7007,1234567896,'teressa@gmail.com');
insert into bo_master values (970169007,7008,1234567897,'joyce@gmail.com');
insert into bo_master values (970169008,7009,1234567898,'catherine@gmail.com');
As part of implementing Data security we would like to encrypt customer sensitive data like ssn , phone_number , email id etc.
Based on the sample data posted in the create and insert statements, Please suggest us how to go with data encryption and decryption .(Hackers should not be able to decrypt the encrypted data).
Encryption should be done while inserting the data.
Encryption should also be done to the existing data in the table.
Decryption should be done while we are retrievingthe data .(while getting the data in the select statements).
Any other inputs on data encryption and decryption are most welcome.
Thnaks and Regards,
Vinesh
and Connor said...
Is this answer out of date? If it is, please let us know via a Comment