Home » SQL & PL/SQL » SQL & PL/SQL » how to encrypt column data (oracle 10g)
how to encrypt column data [message #401936] Thu, 07 May 2009 01:53 Go to next message
navneet_sharma
Messages: 70
Registered: September 2008
Location: New Delhi, India
Member
Hi,
Is there any way to encrypt column data of a table.
does oracle provide any such utility.I know abt translate etc.
is there any other way.

Regards,
Navneet



Re: how to encrypt column data [message #401939 is a reply to message #401936] Thu, 07 May 2009 01:59 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
When you googled for <oracle encrypt data>, which sites did you visit that were unclear?
Re: how to encrypt column data [message #401940 is a reply to message #401936] Thu, 07 May 2009 01:59 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Have a look at the DBMS_CRYPTO package.

MHE
Re: how to encrypt column data [message #401946 is a reply to message #401936] Thu, 07 May 2009 02:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
navneet_sharma wrote on Thu, 07 May 2009 08:53
Hi,
Is there any way to encrypt column data of a table.
does oracle provide any such utility.I know abt translate etc.
is there any other way.

Regards,
Navneet

And the first question you have to answer is: you want to protect what against who in which circonstances.

Regards
Michel

Re: how to encrypt column data [message #401947 is a reply to message #401940] Thu, 07 May 2009 02:14 Go to previous messageGo to next message
navneet_sharma
Messages: 70
Registered: September 2008
Location: New Delhi, India
Member
Hi,
Thanks for your reply.I am still unclear how to use dbms_crypto package.My datatype of the column which I need to encrypt is number(10) and if I m using this pkg to encrypt i will be storing the values in other columns of LOB type.
I want to store the encryption in same column.

Regards,
Navneet
Re: how to encrypt column data [message #401959 is a reply to message #401947] Thu, 07 May 2009 02:49 Go to previous messageGo to next message
user2004
Messages: 33
Registered: April 2009
Member
TRANSLATE?
Re: how to encrypt column data [message #401974 is a reply to message #401947] Thu, 07 May 2009 03:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Create your own algorithm. Standard ones returns raw (untyped) data.

Regards
Michel
Re: how to encrypt column data [message #401976 is a reply to message #401959] Thu, 07 May 2009 03:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
user2004 wrote on Thu, 07 May 2009 09:49
TRANSLATE?

Translate works on strings and returns strings.
Or do you mean to translate 0 to 1, 1 to 8... for instance?

Regards
Michel

Re: how to encrypt column data [message #401989 is a reply to message #401976] Thu, 07 May 2009 03:55 Go to previous messageGo to next message
navneet_sharma
Messages: 70
Registered: September 2008
Location: New Delhi, India
Member
michel

exactly ,but generally it is too simple to decipher,i wanted to encrypt using some oracle provided complex algo.i am storing passwords in that column by the way

thanks & regards
navneet
Re: how to encrypt column data [message #401993 is a reply to message #401989] Thu, 07 May 2009 04:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
i am storing passwords in that column by the way

If it is password why is it an integer?
The correct way to store password is not to encrypt it but to hash it (one way encryption) then when you need to check a password you hash the input value and check if it is the same value as the stored one.
See how Oracle works itself.

Regards
Michel

Re: how to encrypt column data [message #401994 is a reply to message #401989] Thu, 07 May 2009 04:03 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Then why do you need it to be a number column?
Passwords should be stored as hashed values. Not to be decrypted.
Previous Topic: 2d position array/varray in plsql
Next Topic: single-row subquery returns more than one row [merged]
Goto Forum:
  


Current Time: Mon Feb 17 04:42:39 CST 2025