how to encrypt column data [message #401936] |
Thu, 07 May 2009 01:53  |
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 #401947 is a reply to message #401940] |
Thu, 07 May 2009 02:14   |
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 #401989 is a reply to message #401976] |
Thu, 07 May 2009 03:55   |
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
|
|
|
|
|