Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

password verify function codes

580896Jun 28 2007 — edited Jun 30 2007
Hi,

The password complexity verification routine performs the following checks:
1 The password has a minimum length of four.
2 The password is not the same as the username.
3 the password is too simple, This is not allowed
....etc.

For these validations i run password_verify function and assign this to profile moreover, I assign profile to <my user>.

For 1: Whenever I changed the password(violation of above rules) from SQLPLUS, gives me error.

ORA-28003: password verification for the specified password failed
ORA-20002: Password length is less than 8. Should be 8 or longer

For 2: ORA-28003: password verification for the specified password failed
ORA-20001: Password same as or similar to username


For 3: I get in sqlplus
ORA-28003: password verification for the specified password failed
ORA-20002: Password too simple. This is not allowed


Now i need to trap these in the form, which error code i need to check in the form? i would appreciate your help please.


IF DBMS_ERROR_CODE = <> THEN ..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 28 2007
Added on Jun 28 2007
16 comments
5,375 views