Sarma Vadlamani
asked on
Oracle Forms
Hi,
I need to write a procedure to validate the following password validations in Oracle Forms
I have a block with OLD Password, Original Password, New Password, and confirm password,
and would like to call the same in When Button Pressed trigger. please advise.
1. 'Password length less than 8'
2. 'Password same as or similar to user'
3. 'Password same as or similar to user name '
4. 'Password same as or similar to server name'
5. 'Password too simple'
6. 'Password same as username reversed'
7. 'Password should contain at least one digit, one lowercase character, one uppercase character, and one punctuation'
8. 'Password should differ from the old password by at least 3 characters'
Thanks.
I need to write a procedure to validate the following password validations in Oracle Forms
I have a block with OLD Password, Original Password, New Password, and confirm password,
and would like to call the same in When Button Pressed trigger. please advise.
1. 'Password length less than 8'
2. 'Password same as or similar to user'
3. 'Password same as or similar to user name '
4. 'Password same as or similar to server name'
5. 'Password too simple'
6. 'Password same as username reversed'
7. 'Password should contain at least one digit, one lowercase character, one uppercase character, and one punctuation'
8. 'Password should differ from the old password by at least 3 characters'
Thanks.
ASKER
I am using that as my base code but when trying to compare old_password and original password
it is not comparing correctly and giving me message even if the password matches to orignal password.
it is not comparing correctly and giving me message even if the password matches to orignal password.
Since your current code is close to publically available code, can you post what you are actually using and sample data?
ASKER
db password validation function is created in oracle database. but i want the same validations with custom messages in oracle forms. i am getting problem with the below
'Password same as username reversed'
'Password should contain at least one digit, one lowercase character, one uppercase character, and one punctuation'
'Password should differ from the old password by at least 3 characters'
i need to write code/validations in oralce forms for the above please advise
'Password same as username reversed'
'Password should contain at least one digit, one lowercase character, one uppercase character, and one punctuation'
'Password should differ from the old password by at least 3 characters'
i need to write code/validations in oralce forms for the above please advise
My hands-on forms coding is very old but remember the logic in the database function being very similar. You should be able to take the logic in the function and move it into forms.
If you can post your forms code, I might be able to help.
If you can post your forms code, I might be able to help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
used the db function
You should be able to take that code as a starting point and apply it to your forms code.
The online docs have the information on the script and its location:
http://docs.oracle.com/cd/E25054_01/network.1111/e16543/authentication.htm#i1007341