Hi Guys,
i need to create a password verify function so as to associate a profile named User_profile the which will be work on basis on two things.
1)password should be greater than 7 characters
2)password should be alpha & Numeric(number)
so could you guys assist me to create the function ?
i do have a verify function like that,please validate below function and tell me what needs to be added for alpha & number must be come in password
CREATE OR REPLACE FUNCTION Verify_function (
username VARCHAR2,
password VARCHAR2,
old_password VARCHAR2)
RETURN BOOLEAN AS
BEGIN
IF LENGTH(password) < 7 THEN
RETURN FALSE;
ELSE
RETURN TRUE;
END IF;
END my_passenf_function;
/
i do have some function like
CREATE PROFILE dbuser_profile LIMIT
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
CONNECT_TIME UNLIMITED
IDLE_TIME UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
COMPOSITE_LIMIT UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LIFE_TIME 30 ---password expire after 90 days
PASSWORD_REUSE_TIME 120 ---- Number of days until a specific password can be reused
PASSWORD_REUSE_MAX 12 ------ The number of changes required before a password can be reused
PASSWORD_LOCK_TIME 1
PASSWORD_GRACE_TIME 5 ---the password expires if it is not changed within the grace period, and further connections are rejected
PASSWORD_VERIFY_FUNCTION Verify_function;
thanks & Regards.