Home » RDBMS Server » Security » How to decrypt DBMS_CRYPTO.HASH encrypted value (10.2.0.5 standard edition Microsoft windows 2008)
How to decrypt DBMS_CRYPTO.HASH encrypted value [message #580707] Wed, 27 March 2013 02:08 Go to next message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Dear ALL,

Please note we need to decrypt the data which is encrypted using dbms_crypto.hash algorithm.Please advice it is possible to decrypt dbms_crypt.hash


eg

SQL> select DBMS_CRYPTO.hash(utl_raw.cast_to_raw('Foo'), 3) FROM dual;

DBMS_CRYPTO.HASH(UTL_RAW.CAST_TO_RAW('FOO'),3)
--------------------------------------------------------------------------------
201A6B3053CC1422D2C3670B62616221D2290929



Thanks,
Anil
Re: How to decrypt DBMS_CRYPTO.HASH encrypted value [message #580708 is a reply to message #580707] Wed, 27 March 2013 02:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot, it is a one-way algorithm.

Regards
Michel
Re: How to decrypt DBMS_CRYPTO.HASH encrypted value [message #580709 is a reply to message #580708] Wed, 27 March 2013 02:16 Go to previous message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Thanks for quick response.

Regards,
Anil
Previous Topic: Connect as sysdba works, regular credentials don't
Next Topic: Keep secure customer data.
Goto Forum:
  


Current Time: Thu Mar 28 15:01:18 CDT 2024