OraFAQ Forum: Security » Encrypt Data in a column in a table

Home » RDBMS Server » Security » Encrypt Data in a column in a table

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Encrypt Data in a column in a table [message #298752]

Thu, 07 February 2008 08:39

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

Report message to a moderator

Re: Encrypt Data in a column in a table [message #298755 is a reply to message #298752]

Thu, 07 February 2008 08:56

ebrian
Messages: 2786
Registered: April 2006

Senior Member

Check Transparent Data Encryption.

Report message to a moderator

Re: Encrypt Data in a column in a table [message #298757 is a reply to message #298755]

Thu, 07 February 2008 09:12

Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA

Senior Member

Thanks!!

Report message to a moderator

Re: Encrypt Data in a column in a table [message #298759 is a reply to message #298757]

Thu, 07 February 2008 09:42

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

Report message to a moderator

Re: Encrypt Data in a column in a table [message #298777 is a reply to message #298757]

Thu, 07 February 2008 11:33

Michel Cadot
Messages: 54226
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

ebrian
Messages: 2786
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.

Report message to a moderator

Re: Encrypt Data in a column in a table [message #298812 is a reply to message #298804]

Thu, 07 February 2008 15:24

Michel Cadot
Messages: 54226
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

Report message to a moderator

Previous Topic:	Applying SSHA algorithm within Oracle
Next Topic:	Knowing the running proudct

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 06:15:28 CDT 2013

Total time taken to generate the page: 0.17999 seconds