Question: I have some locked users
because my password_life_time has expired. I now need
to find a list of all user ID's that have been locked for
passwords. How to I get a list of locked users in
Oracle.
Answer: First, see my notes on password_life_time.
There are many ways that a user ID
can get locked, and you need to monitor for locked users
in your database. For example, you can manually lock a
user with the following command:
alter user username account lock;
You can also
use the following query to find all passwords that have been
locked:
select
username,
account_status
from
dba_users
where
lock_date is not null;
If you
have a locked SYS or SYSTEM password, there may be no way to
recover the password with assistance from Oracle technical
support. In this vase of a locked SYSDBA user, call MOSC at
800-223-1711 or ask MOSC at
http://support.oracle.com
