Oracle Forms


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'

Sarma VadlamaniprogrammeranalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
Oracle provides a pl/sql function that covers the basics for database passwords.

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:

The UTLPWDMG.SQL script checks for the following requirements when users create or modify passwords:

•The password contains no fewer than eight characters and does not exceed 30 characters.

•The password is not the same as the user name, nor is it the user name spelled backward or with numeric characters appended.

•The password is not the same as the server name or the server name with the numbers 1–100 appended.

•The password is not too simple, for example, welcome1, database1, account1, user1234, password1, oracle, oracle123, computer1, abcdefg1, or change_on_install.

•The password includes at least 1 numeric and 1 alphabetic character.

•The password differs from the previous password by at least 3 letters.

Sarma VadlamaniprogrammeranalystAuthor Commented:
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.
slightwv (䄆 Netminder) Commented:
Since your current code is close to publically available code, can you post what you are actually using and sample data?
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Sarma VadlamaniprogrammeranalystAuthor Commented:
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
slightwv (䄆 Netminder) Commented:
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.
Sarma VadlamaniprogrammeranalystAuthor Commented:
thanks i could able to use the database function and the problem is now solved.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sarma VadlamaniprogrammeranalystAuthor Commented:
used the db function
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.