Encryption (merged) [message #301635] |
Thu, 21 February 2008 03:42  |
Jayu
Messages: 14 Registered: August 2007 Location: India
|
Junior Member |
|
|
Hi,
I need to replace the already encrypted data with some * or # symbol..Is this possible using Oracle Pl/SQL??
Basically i have one column in table where i store this encrypted data..Now the encrypted data is stored in form of s!$&6 but i need it in the below given form
*******.This should be stored in Table
Thanks in Advance.
Regards
Jayateerth
|
|
|
|
|
Re: Encryption [message #301672 is a reply to message #301640] |
Thu, 21 February 2008 05:38   |
Jayu
Messages: 14 Registered: August 2007 Location: India
|
Junior Member |
|
|
hi Michel,
Thanks for the reply.But what i want is two levels of encryption/decryption.I get a value from front end and it is stored in database in encrypted form.Again i want this encrypted data to be encrypted(i.e two levels of encryption) and to be stored in the database as '*'.
I am using Oracle 10g R2 database
Thanks in advance
Regards
Jayateerth
|
|
|
Re: Encryption [message #301678 is a reply to message #301672] |
Thu, 21 February 2008 05:53   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Again, how would you decrypt ****?
Suppose password for user 1 is HelloWorld. This encrypts to >sds8t5s. Now you encrypt further to *****
Password for user 2 is AnotherOne. This encrypts to fysar38. Another encryption leads to *****.
How would you check if the correct password is entered if everything encrypts towards ****?
|
|
|
Re: Encryption [message #301755 is a reply to message #301678] |
Thu, 21 February 2008 09:45   |
Jayu
Messages: 14 Registered: August 2007 Location: India
|
Junior Member |
|
|
Hi Frank,
Thanks for the reply...Then According to you its impossible to have 2nd level of encryption in DB side in such a way that it stores asterisk or hash(* or #) in the database.
Please suggest if any other approaches are there..
Thanks
Regards
Jayateerth
|
|
|
|
|
Encryption1 [message #301836 is a reply to message #301635] |
Thu, 21 February 2008 23:41   |
Jayu
Messages: 14 Registered: August 2007 Location: India
|
Junior Member |
|
|
Hi,
Is it possible in Oracle database to display astersik or hash symbol in one Column(say password) of the table??Presntly i am storing password in encrypted form but i want to show it as * or # in column of the table.
Thanks
Regards
Jayateerth
|
|
|
Re: Encryption1 [message #301842 is a reply to message #301836] |
Fri, 22 February 2008 00:04  |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Don't start a new thread; continue in your old thread if the subject does not change.
If you are asking if it is possible to _store_ the encrypted data as asterisks, then the answer is No.
Answer anacedents question: what business problem are you trying to solve? If you answer that, we might come up with a reasonable solution.
|
|
|