Home » RDBMS Server » Security » Encrypt Data in a column in a table
Encrypt Data in a column in a table [message #298752] Thu, 07 February 2008 08:39 Go to next message
Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA
Senior Member
Does anyone know how to encrypt the data in a column in a table? I have a client that has a new table that will hold faculty salary information and they want to encrypt the salary column in their in-house table.

Any suggestions.

Anne

Re: Encrypt Data in a column in a table [message #298755 is a reply to message #298752] Thu, 07 February 2008 08:56 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check Transparent Data Encryption.
Re: Encrypt Data in a column in a table [message #298757 is a reply to message #298755] Thu, 07 February 2008 09:12 Go to previous messageGo to next message
Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA
Senior Member
Thanks!!
Re: Encrypt Data in a column in a table [message #298759 is a reply to message #298757] Thu, 07 February 2008 09:42 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

What is your oracle version TDE works only in 10gr2.
if your on <= 10gr2 then use DBMS_OBFUSCATION_TOOLKIT.

Regards
Taj
Re: Encrypt Data in a column in a table [message #298777 is a reply to message #298757] Thu, 07 February 2008 11:33 Go to previous messageGo to next message
Michel Cadot
Messages: 59165
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TDE is a paying option.
You can use DBMS_CRYPTO.

Encryption is there to prevent from file theft and not from illegal access.
If you want to protect against accesses,, use views or VPD.

Regards
Michel

[Updated on: Thu, 07 February 2008 11:33]

Report message to a moderator

Re: Encrypt Data in a column in a table [message #298804 is a reply to message #298777] Thu, 07 February 2008 14:47 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Michel Cadot wrote on Thu, 07 February 2008 12:33

Encryption is there to prevent from file theft and not from illegal access.

If illegal access is the objective, then Data Vault would be the OP's only option.
Re: Encrypt Data in a column in a table [message #298812 is a reply to message #298804] Thu, 07 February 2008 15:24 Go to previous message
Michel Cadot
Messages: 59165
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Vault is the next step after view and VDP.
Database Vault adds preventing accesses from privileged users like DBA.

Regards
Michel
Previous Topic: Applying SSHA algorithm within Oracle
Next Topic: Knowing the running proudct
Goto Forum:
  


Current Time: Mon Sep 22 11:38:43 CDT 2014

Total time taken to generate the page: 0.08677 seconds