Skip to Main Content

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!

user locked, no lock date

EdStevensJan 17 2012 — edited Jan 17 2012
Anyone seen anything like this before?

User is locked, but lock date is null
SQL> select username, account_status, lock_date
  2  from dba_users
  3  where account_status like 'LOCK%';

USERNAME             ACCOUNT_ST LOCK_DATE
-------------------- ---------- -----------
<snip other users>
MYAPPUSER            LOCKED

15 rows selected.
Account has locked multiple times today. Notice status is simply LOCKED, not LOCKED(TIMED) as it would be if wrong password entered too many times.
This post has been answered by Pierre Forstmann on Jan 17 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 14 2012
Added on Jan 17 2012
4 comments
3,671 views