Home » SQL & PL/SQL » SQL & PL/SQL » Encrypting an 9 position field
Encrypting an 9 position field [message #394113] Wed, 25 March 2009 14:06 Go to next message
eddie909
Messages: 1
Registered: March 2009
Junior Member
I am looking for a way to encrypt an 9 position field on a table and a way to decrypt the value. Someone suggested using a secret number then add that number to the value.

Ex. Secret number is 2 and the real balance value is 123456123 then the encrypted value will be 12345125.

Is there any Oracle Encryption process that I can use that will keep the Encryption value as a 9 position field?

Thanks,

Ed
Re: Encrypting an 9 position field [message #394116 is a reply to message #394113] Wed, 25 March 2009 14:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Such a way is not encryption, it is at most obfuscation and does not resist very long to one who wants to know it.
If you really want to encrypt use something like dbms_crypto.

Regards
Michel
Re: Encrypting an 9 position field [message #394231 is a reply to message #394113] Thu, 26 March 2009 04:23 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
For Oracle 9i, they supply the beautifully named DBMS_OBFUSCATION_TOOLKIT for 9i which provides the ability to do DES and triple DES encryption.

Re: Encrypting an 9 position field [message #394313 is a reply to message #394113] Thu, 26 March 2009 07:58 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
eddie909 wrote on Wed, 25 March 2009 15:06

Ex. Secret number is 2 and the real balance value is 123456123 then the encrypted value will be 12345125.



I would say that is pretty good encryption as I can't figure out how 2 will turn 123456123 into 12345125. I think the secret number here is -111110998.
Previous Topic: search a whole table
Next Topic: Insert Record in extenal table?
Goto Forum:
  


Current Time: Wed Feb 19 02:58:57 CST 2025