Auditing an Oracle database for security issues is very important. PeteFinnigan.com provides all of the information and tools that you will need Click here for details of PeteFinnigan.com Limited's detailed Oracle database security audit service Click here for details of PeteFinnigan.com Limited's Oracle Security Training Courses
Cookie Policy:We only use essential cookies on small sections of this website. For details see here.

Welcome, Guest. Please Login.
Nov 20th, 2017, 1:42am
News: If you would like to register contact the forum admin
Home | Help | Search | Members | Login
   Pete Finnigan's Oracle Security Forum
   Oracle Security
   Oracle Security
(Moderator: Pete Finnigan)
   Making a colum gibberish/TDE
« Previous topic | Next topic »
Pages: 1  Reply | Notify of replies | Send Topic | Print
   Author  Topic: Making a colum gibberish/TDE  (Read 3241 times)
matvrix
PeteFinnigan.com Newbie
*



I love YaBB 1G - SP1!

   
View Profile |

Posts: 1
Making a colum gibberish/TDE
« on: Aug 14th, 2010, 8:55pm »
Quote | Modify

Trying to set a table column with TDE using the instructions detailed at :
_http://oracleflash.com/26/Oracle-10g-Transparent-Data-Encryption-exampl es.html.
_http://www.oracle.com/technology/obe/10gr2_db_vmware/security/tde/tde.h tm
 
How could this technology be leveraged so that encrypted column, when rendered by a
statement  in sql plus-
 
>>select SENSITIVE_DATA from tde;
 
produce a result set of this sort :
 
SENSITIVE_DATA(Password)
------------------------------
/*^@@_%^$&%^&^%
 
Essentially, would like the column to be rendered unreadable when requested.
 
 
Regards,
John
IP Logged
Marcel-Jan
PeteFinnigan.com Junior Member
**






   
View Profile | WWW |

Gender: male
Posts: 83
Re: Making a colum gibberish/TDE
« Reply #1 on: Aug 16th, 2010, 10:54am »
Quote | Modify

I've experimented with TDE myself and that isn't how TDE works.
 
The thing about TDE is that it encrypts data on datafile level and backup level so that when your disks or backup tapes fall in the wrong hands, they can't retrieve data by examining the datafiles.
 
But when you normally log in you'll find that the data selected is as readable as it ever were.  
 
To encrypt data in columns in such a way that you need a key to decrypt it, you'll need to change your application (if at all possible). You'll need the package dbms_crypto (10g and up) (http://psoug.org/reference/dbms_crypto.html) to encrypt/decrypt data written by the application. Without that the data is unreadable.
 
Or maybe all you need is to make data unreadable for all in, for example, a test database. That's called data masking. Oracle has a tool for that (the Oracle Data Masking Pack (http://www.oracle.com/technology/products/oem/pdf/ds_datamasking.pdf)) which works from Enterprise Manager, but I have no experiences with that. I believe there are other commercial data masking tools as well.
IP Logged
Pages: 1  Reply | Notify of replies | Send Topic | Print

« Previous topic | Next topic »

Powered by YaBB 1 Gold - SP 1.4!
Forum software copyright 2000-2004 Yet another Bulletin Board