Skip to Main Content
  • Questions
  • Data Encryption And Decryption In Tables

Breadcrumb

May 4th

Question and Answer

Connor McDonald

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...

You'll be wanting transparent data encryption

See

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:906227800346393844

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:44742967463133

for examples of this. Note this is part of the Advanced Compression option .

Is this answer out of date? If it is, please let us know via a Comment