Help! Oracle 9i User Profile trouble
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
