Printable View
Hi,
I need to authenticate in my Java application based on Database users. Is there anyway to generate the HASH value of the Oracle password of the user logging in so as to compare it with the Password column of the DBA_USERS table?
Kindly help.
Thanks in advance
Vikas
Yes, you can use it.Quote:
Originally Posted by vikascv
TamilCode:1 select dbms_utility.get_hash_value(password,1000000,9999999)
2 from dba_users
3* where username = 'TAMIL'
20:04:39 SQL> /
DBMS_UTILITY.GET_HASH_VALUE(PASSWORD,1000000,9999999)
-----------------------------------------------------
7531882
Here you are simply rehashing (with a different hash alghorythm) allready hashed password. This is not what the original poster wants - he wants to hash user-supplied plain text password and then compare that hash value with the hash stored in DBA_USERS.PASSWORD.Quote:
Originally Posted by tamilselvan
Vikascv, I don't think there is any Oracle's built in package/procedure/function that implements the hashing alghorytm used for storing database passwords. But the alghorytm that Oracle uses for hashing passwords has allready been published and described on various internet oracle-related forums, so it should not be too hard to create that functionality in the language of your choice. Use google.....
Sorry, I misunderstood the question.Quote:
Here you are simply rehashing (with a different hash alghorythm) allready hashed password. This is not what the original poster wants - he wants to hash user-supplied plain text password and then compare that hash value with the hash stored in DBA_USERS.PASSWORD
Tamil