I am relatively new in Oracle forms 10g. I have my application users as records in one of the application table called users. The table has username,passwd and usergroup as its column. I would like to encrypt the passwords on oracle forms 10 g before storing them in the table. During login the user will provide a password which should then be encrypted in Oracle forms before comparing it with what was stored for the user. Kindly assist.
I would not encrypt, I would hash it using DBMS_UTILITY.GET_HASH_VALUE.
An encrypted password could be decrypted, a hashed password can not be unhashed. You store it hashed and you compare the entered password after it is hashed. This is the same procedure that oracle uses.
You do not need a parachute to skydive. You only need a parachute to skydive twice.