code to check the password at least one upper case letter
I receive a task to setup so it can check the complexity of the password. I use utlpwdmg.sql to modify to meet the requirement at our site. The script does not check the password to have at least one upper case letter. I googled it and so far it said that oracle does not have the capability of checking the case sensitive until 11g patch. Our site database is 10g. Is there workaround or suggestion of what I can do or look. I truthly appreciate it.
Why not just use or customize the Oracle supplied sql code?
Oracle Database provides a sample password verification function in the PL/SQL script UTLPWDMG.SQL (located in ORACLE_BASE/ORACLE_HOME/RDBMS/ADMIN) that, when enabled, checks whether users are correctly creating or modifying their passwords.
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.