Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Account lock from password_lock_time - Automatic unlock not working

maddoxSep 28 2012 — edited Oct 22 2012

Oracle 11g database

I have created a profile with password_lock_time = .01389 (20/1440), set up a test user, and set the user to the new profile. Then I logged in with an invalid password several times and verified from dba_users that the account_status = LOCKED (TIMED). The problem is that several hours later the account has still not unlocked. Am I missing a step or does 11g not allow a fraction to be used for the lock time?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 19 2012

Added on Sep 28 2012

#11g, #general-database-discussions, #oracle

7 comments

21,507 views