Lock 和 UnLOCK 一个用户

Here's how to lock or unlock Oracle database user accounts.

SQL> ALTER USER username ACCOUNT LOCK;

SQL> ALTER USER username ACCOUNT UNLOCK;



也可以用
update applsys.fnd_user
set end_date = NULL
where user_name = 'user_name';