Help! Oracle 9i User Profile trouble

From: Tim <dehabatj_at_yahoo.com>
Date: 11 Jun 2002 08:06:09 -0700
Message-ID: <94f4302.0206110706.6d6beb64_at_posting.google.com>


I recently migrated one of my Oracle 8.1.7 Databases to 9.0.1. The migration went smoothly and everything appears to be normal except that my user profile for a certain group of application users that access this database is not working properly. The profile was created as such:
CREATE PROFILE "APP_USER_PROF"
    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 UNLIMITED 
    PASSWORD_GRACE_TIME 3 
    PASSWORD_LIFE_TIME 90 
    PASSWORD_REUSE_MAX 1 
    PASSWORD_REUSE_TIME UNLIMITED 
    PASSWORD_VERIFY_FUNCTION DEFAULT;


In 8i this profile works just fine it allows the user to re-use old passwords after one change. In 9i it will not allow my users to re-use old passwords no matter how many times there password has changed since. I have tried re-creating the profile with no luck. I have tried modifying the password with no luck. I can not find anything documented about changes in the way profiles are used between 8i and 9i. I know the resource limits parameter does not pertain to password resources but I even tried that just in case, no luck there. I have even gone so far as bring a test database back to 8i, in which the profile once again worked properly. Any suggestions would be greatly appreciated.
Thank You,
Tim
dehabatj_at_yahoo.com Received on Tue Jun 11 2002 - 17:06:09 CEST

Original text of this message