Click here to Skip to main content
15,314,843 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi..
I am woeking on a project in php that uses oracle database as back end.
I want to encrypt the user provided password while storing it into database.
And while checking weather user provided password and system stored password is same we can use a function to do that in oracle.
I know that for both this there is hash function and de hash function with password_verify function in mysql for doing the above mentioned tasks.
But I am worried about oracle db is there any function in oracle that does this job and is also compatible with php?

What I have tried:

I have tried all above mentioned function in oracle but its not working.
Pls help.
Posted
Updated 8-Aug-18 4:45am

Quote:
there is hash function and de hash function
No, there isn't. That's the whole point of hashing as opposed to encryption: there is no way to "reverse" a hashed value and obtain the original input.

And that's why you use it: encrypted passwords are not secure, because the decryption key must be known to the software when the user logs in. Hashing a password - with a salt value - creates a non-unique (but from a very large phase space) value which you then compare directly to the stored hash value. If they match, the password is correct and you let the user in. If they don't, it isn't correct and they can go whistle. But no-one (even you or anyone who accesses your software and / or database complete with source code) can find out what the original password was.
   
Comments
Vignesh Iyer 8-Aug-18 9:40am
   
So how to safeguard user provided password?
OriginalGriff 8-Aug-18 9:50am
   
You hash it, as I said.
See here: the code is C#, but it's pretty obvious.
https://www.codeproject.com/Tips/186585/Password-Storage-How-to-do-it
Vignesh Iyer 8-Aug-18 9:41am
   
And how to go through it?
Why have you reposted this question? I already explaine what you need to do at What funation to use for password encryption in oracle while working with PHP[^].
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900