Home » SQL & PL/SQL » SQL & PL/SQL » Encryption of data in a column (oracle 9i)
Encryption of data in a column [message #318164] Mon, 05 May 2008 23:53 Go to next message
me_arindam
Messages: 26
Registered: March 2008
Location: India
Junior Member
Hi,

I need to encrypt the whole data of a column (id) of a table.
The column is of number(7).
I have tried to use dbms_obfuscation_toolkit. But it didn't work.
for dbms_obfuscation_toolkit the string to be updated must be multiple of 8 bytes. I have tried to use lpad also...
But the datatype of the column is number. It doesn't alow to update the column data with the encrypted string(varchar2 or raw)

Can someone help me how can I encrypte the data of that column.

Thanks,
Arindam
Re: Encryption of data in a column [message #318180 is a reply to message #318164] Tue, 06 May 2008 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you want to encrypt then the target column must be, in the end, RAW whatever the meaning it has for you (here a number).
So you have to change the type in your table and use dbms_obfuscation_toolkit each you want to access the column to convert from/to number to/from raw.

Regards
Michel
Re: Encryption of data in a column [message #318284 is a reply to message #318164] Tue, 06 May 2008 06:28 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
As a side note, this should be easier for you once you upgrade your database version to a current release. A feature called TDE (Transparent Data Encryption). You'll want to look into that, and it may be justification for you to upgrade.
Re: Encryption of data in a column [message #318293 is a reply to message #318180] Tue, 06 May 2008 07:09 Go to previous messageGo to next message
me_arindam
Messages: 26
Registered: March 2008
Location: India
Junior Member
Hi Michel,

Could you please explain it in more detail.
The column is used in more than 20 tables.

Other than changing the datatype of the column in those tables is there any other way to encrypt?

Thanks,
Arindam
Re: Encryption of data in a column [message #318303 is a reply to message #318293] Tue, 06 May 2008 07:50 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Build your own enccyption algorithm that will keep the datatype.

Regards
Michel
Previous Topic: which OS user has dropped the objects
Next Topic: delete
Goto Forum:
  


Current Time: Sat Dec 10 14:54:40 CST 2016

Total time taken to generate the page: 0.08024 seconds