How to differentiate in oracle a user deliberately locked by the security administrator and locked due to unsuccessful login attempts

1 Answer 1


Select the user information from dba_users and look at the ACCOUNT_STATUS. If the status is LOCKED then the user was deliberately locked. If it is LOCKED(TIMED) then it is locked because of multiple wrong passwords. If you have set the PASSWORD_LOCK_TIME then the user will be unlocked after this time is reached.

select   username, account_status
from     dba_users
where    username='A-USERNAME'
  • Thanks. This was the case until some policy was recently modified by our DBA -set something to "default" (I am just an end user monitoring user access to our several systems). After this policy was implemented, either way the status is simply LOCKED. Should I ask the DBA to set the policy to whatever it was earlier?
    – Jack
    Commented Oct 11, 2016 at 13:24
  • The DBA sets the user profiles. You can ask him to either change (back) the profile. Perhaps he is not aware that it changed or he had some reason for the change. If you want more information about the user profiles then check the documentation or ask your DBA.
    – Marco
    Commented Oct 11, 2016 at 13:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.