Database Administration (MOSC)

MOSC Banner

how to disable account lock?

edited Jan 23, 2012 2:29AM in Database Administration (MOSC) 4 commentsAnswered ✓
Currently, I set the password_lock_time to unlimited. Does this mean that if the failed_login_attempts has met, the account will be always lock, or does that mean the account will not be locked at all? I just searched the web, it says password_lock_time – This specifies how long to lock the account after the failed login attempts is met. Most DBA’s set this value to UNLIMITED. I wonder how can I disable the account lock temporarily? That is even if the failed_login_attempts has met, the account won't be locked. Is there a way to do this? Or, should I just change the failed_login_attempts to unlimited? My version is 11.2.0.2 on solaris 10. Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center