Password Reuse Max question
Dan AMar 25 2008 — edited Jun 5 2010Hi.
We have a consultant installing software on our dev. database. He tells me that he gets this message: ora-28007: the password cannot be reused when he tries to reset the users password. The user, after I checked, has teh DEFAULT profile, and for default profile we have this:
SQL> select resource_name, limit from dba_profiles where profile = 'DEFAULT';
RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME UNLIMITED
CONNECT_TIME UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED
RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX 12
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_LOCK_TIME UNLIMITED
PASSWORD_GRACE_TIME UNLIMITED
16 rows selected.
So, what can I infer from this? That the consultant has dropped the user / changed the user's password more than 12 times?
Not sure what to tell him.
thanks
DA