How does the profile limit for PASSWORD_REUSE_MAX works for Oracle Enterprise Database 9i ? Suppose we set PASSWORD_REUSE_MAX to 5 in a profile for a user. Now this user tries to change his password, then at that point how does Oracle engine checks if the new password the user is giving matches to any he has already used ? Does Oracle stores the old passwords somewhere in the dictionary to crosscheck. Can we see those old passwords. I know we can see the last password from USERS$ tables what about the older ones ?
April 14, 2010 3:14 PM
April 15, 2010 6:45 PM