Password verify function with following checks. We can use password function provided by ORACLE but it contains around 9 checks like: 1.Check if the password is same as the username 2.Check if the password is same as the username reversed 3.Check if the password differs from the previous password by at least 3 letters 4.Check if the password is the same as server name 5.Check if the password is too simple. A dictionary of words may be maintained and a check may be made so as not to allow the words that are too simple for the password. 6.Check if the password is the same as oracle But it doesn't contain "One Capital Letter Check" Below Function with 4 checks only, customized as per customer requirement : *minimum length of 8 characters * one capital letter * one number * one special character ========================== CREATE OR REPLACE FUNCTION verify_function_anil (username varchar2, password varchar2, old_password
