Link to home
Start Free TrialLog in
Avatar of SAURAVKUMAR58
SAURAVKUMAR58

asked on

How to decrypt the encrypted password ? Any good algorithm or PL/SQL Code??

how to decode the encrypted passwords stored in one oracle table ? Is there any PL/SQL Code or function or procedure is availible to decode that passwords??????
ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It depends.
I will prevent you to decode encoded data. This can harm your reputation and cause you
big troubles. A good way is to report the facts in written to your boss and to ask what to do.

It depends what and how is the data coded.
In the easiest way (Transperant Data Encryption) you can export the data (Data Pump, 10g and over) and in the export file they will be decrypted. If you are allowed to work as user SYS.
Avatar of gajmp
gajmp

you can use the below things
for encryptstring
dbms_obfuscation_toolkit and utl_raw.cast_to_raw

for decryptstring
dbms_obfuscation_toolkit and utl_raw.cast_to_varchar2
SAURAVKUMAR58,
     It's been over a month.  Could you please decide if the comments posted here justify an award, or post something about how you were able to solve your problem or the path you had to take based on your findings?  Thank you.

Good luck!