Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2009
    Posts
    30

    Question Unanswered: About ORA_HASH Function

    Hello All,

    I have stored the password in the database column with the help of OAR_HASH function.If I want to retrive the original value, means I want to decrypt the value which is get stored through ORA_HASH function.Then how can I decrypt it ?

    E.g. - The value for james is 1236057532.(produced by ORA_HASH function)
    I want to decrypt this 1236057532 value.

    Will any body plz tell me how to do this?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Then how can I decrypt it ?
    You do not decrypt. It is a 1 way HASH.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2009
    Posts
    30
    Hello anacedent,

    Thanks for your reply.

    If in a future for some reason I want to know the password for some user then I will never come to know the text value ?Then it will create a problem because everytime I need to convert the value througn ORA_HASH.There is no simple way to bring the value back to plain text ?

    E.g. The value for james is 1236057532.(produced by ORA_HASH function)
    some oracle function(1236057532)
    ans = james.
    Last edited by shende.tejas; 06-04-09 at 04:43.

  4. #4
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    As anacedent said: it's a one way hash, you can not reconstruct the orginal value from the hash.

    One of the reasons is, that different input values (passwords) might end up with the same hash value.

  5. #5
    Join Date
    Apr 2009
    Posts
    30
    Hello shammat

    So it's just impossible to recover the original value.

    Thanks for your replay.

  6. #6
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Correct, which is why most passwords are stored this way. As an administrator, you can change the password, but you can't find out what the current password is.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •