Login authentication against Database user?

[tamilselvan]

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.

 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

Tamil