I have created a test profile:
CREATE PROFILE "TEST_3DAYS"
LIMIT CPU_PER_SESSION DEFAULT CPU_PER_CALL DEFAULT
CONNECT_TIME DEFAULT IDLE_TIME DEFAULT SESSIONS_PER_USER
DEFAULT LOGICAL_READS_PER_SESSION DEFAULT
LOGICAL_READS_PER_CALL DEFAULT PRIVATE_SGA DEFAULT
COMPOSITE_LIMIT DEFAULT FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LOCK_TIME DEFAULT PASSWORD_GRACE_TIME 3
PASSWORD_LIFE_TIME 3 PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_REUSE_TIME 365 PASSWORD_VERIFY_FUNCTION
VERIFY_FUNCTION
When signing into SQLPLUS after the password expires I would expect a
message to change password but is recieving none.....
Received on Thu Apr 22 2004 - 10:02:11 CDT
