SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jul 14 18:12:38 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
SQL> conn sys/sys as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> desc dba_users
Name                                   Null?    Type
----------------------------------------- -------- ----------------------------
USERNAME                         NOT NULL VARCHAR2(30)
USER_ID                             NOT NULL NUMBER
PASSWORD                                 VARCHAR2(30)
ACCOUNT_STATUS                   NOT NULL VARCHAR2(32)
LOCK_DATE                                       DATE
EXPIRY_DATE                                    DATE
DEFAULT_TABLESPACE                    NOT NULL VARCHAR2(30)
TEMPORARY_TABLESPACE                      NOT NULL VARCHAR2(30)
CREATED                            NOT NULL DATE
PROFILE                             NOT NULL VARCHAR2(30)
INITIAL_RSRC_CONSUMER_GROUP                      VARCHAR2(30)
EXTERNAL_NAME                                    VARCHAR2(4000)
SQL> set lines 200
SQL> select username,account_status from dba_users;
USERNAME                 ACCOUNT_STATUS
------------------------------ --------------------------------
SYS                      OPEN
SYSTEM                      OPEN
DBSNMP                            OPEN
SCOTT                        OPEN
OUTLN                        EXPIRED & LOCKED
WMSYS                       EXPIRED & LOCKED
ORDSYS                      EXPIRED & LOCKED
ORDPLUGINS                    EXPIRED & LOCKED
MDSYS                       EXPIRED & LOCKED
CTXSYS                      EXPIRED & LOCKED
XDB                            EXPIRED & LOCKED
USERNAME                 ACCOUNT_STATUS
------------------------------ --------------------------------
ANONYMOUS                    EXPIRED & LOCKED
WKSYS                       EXPIRED & LOCKED
WKPROXY                  EXPIRED & LOCKED
ODM                           EXPIRED & LOCKED
ODM_MTR                 EXPIRED & LOCKED
OLAPSYS                   EXPIRED & LOCKED
HR                        EXPIRED & LOCKED
OE                        EXPIRED & LOCKED
PM                       EXPIRED & LOCKED
SQL> alter user hr account unlock;（解锁）
User altered.
SQL> select username,account_status from dba_users;
USERNAME                 ACCOUNT_STATUS
------------------------------ --------------------------------
SYS                      OPEN
SYSTEM                      OPEN
DBSNMP                            OPEN
SCOTT                        OPEN
HR                        EXPIRED
OUTLN                        EXPIRED & LOCKED
WMSYS                       EXPIRED & LOCKED
ORDSYS                      EXPIRED & LOCKED
ORDPLUGINS                    EXPIRED & LOCKED
QL> alter user hr identified by hr;（更改密码）
User altered.
SQL> select username,account_status from dba_users;
USERNAME                 ACCOUNT_STATUS
------------------------------ --------------------------------
SYS                      OPEN
SYSTEM                      OPEN
DBSNMP                            OPEN
SCOTT                        OPEN
HR                        OPEN
OUTLN                        EXPIRED & LOCKED
SQL> conn hr/hr
Connected.
SQL> conn /as sysdba
Connected.
SQL> alter user hr account lock;（加锁）
User altered.
SQL> select username,account_status from dba_users;
USERNAME                 ACCOUNT_STATUS
------------------------------ --------------------------------
SYS                      OPEN
SYSTEM                      OPEN
DBSNMP                            OPEN
SCOTT                        OPEN
HR                        LOCKED
OUTLN                        EXPIRED & LOCKED
SQL> alter user hr password expire;（密码失效）
User altered.
SQL> select username,account_status from dba_users;
USERNAME                 ACCOUNT_STATUS
------------------------------ --------------------------------
SYS                      OPEN
SYSTEM                      OPEN
DBSNMP                            OPEN
SCOTT                        OPEN
OUTLN                        EXPIRED & LOCKED
WMSYS                       EXPIRED & LOCKED
OLAPSYS                   EXPIRED & LOCKED
HR                        EXPIRED & LOCKED
OE                        EXPIRED & LOCKED
PM                       EXPIRED & LOCKED
SQL> conn hr/hr
ERROR:
ORA-28000: the account is locked
Warning: You are no longer connected to ORACLE.