This discussion is archived
1 Reply Latest reply: Aug 14, 2010 4:18 PM by AndyKlock RSS

encrypt a colum and make it gibberish using TDE

user4583444 Newbie
Currently Being Moderated
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/10gr2db_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.
  • 1. Re: encrypt a colum and make it gibberish using TDE
    AndyKlock Journeyer
    Currently Being Moderated
    It can't. Oracle TDE encrypts data at the OS file level. It protects data from someone directly accessing the data files. You need to have an Oracle wallet and if you don't you'll get something like "ORA-28365: wallet is not open" when trying to access encrypted data. What you are describing can be done with something like DBMS_CRYPTO:

    http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_crypto.htm

    You'll need to encrypt the data on on insert (and update) and then decrypt it when read. It's good that you are working on encrypting data. It's a valuable skill.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points