Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.freenet.de!border2.nntp.ams.giganews.com!nntp.giganews.com!news2.euro.net!newshub3.home.nl!newshub1.home.nl!home.nl!not-for-mail
From: Frank van Bortel <frank.van.bortel@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle and Encryption
Date: Tue, 10 Oct 2006 19:52:17 +0200
Organization: @Home Benelux
Lines: 20
Message-ID: <eggm8s$n4f$1@news3.zwoll1.ov.home.nl>
References: <12ig66kecmh8jc7@news.supernews.com> <pan.2006.10.09.03.53.31.927762@verizon.net> <1160385548.882720.146260@k70g2000cwa.googlegroups.com> <pan.2006.10.09.11.53.55.327151@verizon.net> <newscache$w8vv6j$vnc$1@newsfront4.netvisao.pt>
Reply-To:  frank.van.bortel@gmail.com
NNTP-Posting-Host: cc28855-a.hnglo1.ov.home.nl
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news3.zwoll1.ov.home.nl 1160502364 23695 82.75.95.92 (10 Oct 2006 17:46:04 GMT)
X-Complaints-To: usenet@corp.home.nl
NNTP-Posting-Date: Tue, 10 Oct 2006 17:46:04 +0000 (UTC)
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
In-Reply-To: <newscache$w8vv6j$vnc$1@newsfront4.netvisao.pt>
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276962

Pedro Lopes schreef:
> If running on 10gR2, TDE (transparent data encryption) is the way to go.
> 

No, it is not, because anyone granted to see the column
can see it's contents, and the OP said:

 > I would like to keep it in its encrypted form in the
 > database but I would like to be able to show it to certain privileged
 > people based on a password.

Why do you think TDE is called Transparant? I had some trouble with
proving the encryption, too. Looks for TDE how to on:
http://vanbortel.blogspot.com/2005_07_01_vanbortel_archive.html

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...