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.
Sep 18th, 2019, 10:27am
News: Welcome to Pete Finnigan's Oracle security forum
Home | Help | Search | Members | Login
   Pete Finnigan's Oracle Security Forum
   Oracle Security
   Oracle Security
(Moderator: Pete Finnigan)
   Transparent Data Encryption
« Previous topic | Next topic »
Pages: 1  Reply | Notify of replies | Send Topic | Print
   Author  Topic: Transparent Data Encryption  (Read 4194 times)
Pete Finnigan
PeteFinnigan.com Administrator
*****




Oracle Security is easier if you design for it

   
View Profile | WWW | Email

Gender: male
Posts: 309
Transparent Data Encryption
« on: May 7th, 2006, 2:40pm »
Quote | Modify

Oracle 10g Release 2 has a new tool is Transparent Data Encryption.
One of the important features is allow you to encrypt Index column that minimize the performance reduction.
http://www.eweek.com/article2/0,1895,1837854,00.asp
 
I don't know they encryp the data before index or encryp the indexed data
Can you explain to me or show me some thing?
Thank you
Edit/Delete Message
IP Logged

Pete Finnigan (email:pete@petefinnigan.com)
Oracle Security Web site: http://www.petefinnigan.com
Forum: http://www.petefinnigan.com/forum/yabb/YaBB.cgi
Oracle security blog: http://www.petefinnigan.com/weblog/entries/index.html
Pete Finnigan
PeteFinnigan.com Administrator
*****




Oracle Security is easier if you design for it

   
View Profile | WWW | Email

Gender: male
Posts: 309
Re: Transparent Data Encryption
« Reply #1 on: May 7th, 2006, 10:30pm »
Quote | Modify

Hi,
 
Sorry I moved your post to here as your question is about a database add-on feature rather than a tool.
 
Let me try and answer your question. TDE encrypts data at the file level. Any read or write of the data involves a "transparant" encrypt/decrypt before the user gets the data or before it goes back to disc. This feature is very useful for protecting the "data at rest", i.e. when its in the data files or when written to a backup tape. It is not useful for encrypting data within the database. Because of the way that it works its possible to encrpt index columns as the encrypt/decrypt occurs at the hardware abstraction layer so as far as the Oracle kernel is concerned its clear text data.
 
hth
 
cheers
 
Pete
IP Logged

Pete Finnigan (email:pete@petefinnigan.com)
Oracle Security Web site: http://www.petefinnigan.com
Forum: http://www.petefinnigan.com/forum/yabb/YaBB.cgi
Oracle security blog: http://www.petefinnigan.com/weblog/entries/index.html
Pete Finnigan
PeteFinnigan.com Administrator
*****




Oracle Security is easier if you design for it

   
View Profile | WWW | Email

Gender: male
Posts: 309
Re: Transparent Data Encryption
« Reply #2 on: May 9th, 2006, 6:33pm »
Quote | Modify

Thank you, Peter.
So, I understand that the Data is encrypted before it is indexed. For this reason, we can
- Create an index on an encrypted column only when NO SALT is specified.
- Index range scans are supported for equality searches only.
I hope I understand this right.
IP Logged

Pete Finnigan (email:pete@petefinnigan.com)
Oracle Security Web site: http://www.petefinnigan.com
Forum: http://www.petefinnigan.com/forum/yabb/YaBB.cgi
Oracle security blog: http://www.petefinnigan.com/weblog/entries/index.html
Pete Finnigan
PeteFinnigan.com Administrator
*****




Oracle Security is easier if you design for it

   
View Profile | WWW | Email

Gender: male
Posts: 309
Re: Transparent Data Encryption
« Reply #3 on: Jul 3rd, 2006, 5:04am »
Quote | Modify

hi..
i'm a new comer in this forum.
i interested about trasparent data encryption,
but i don't know how tde works.
would you mind giving me references about tde?
thanks before
IP Logged

Pete Finnigan (email:pete@petefinnigan.com)
Oracle Security Web site: http://www.petefinnigan.com
Forum: http://www.petefinnigan.com/forum/yabb/YaBB.cgi
Oracle security blog: http://www.petefinnigan.com/weblog/entries/index.html
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