oracle用户解锁/加锁

[oracle@jieshi9i ~]$ sqlplus /nolog

 

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jul 14 18:12:382009

 

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

 

SQL> conn /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 NULLVARCHAR2(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 fromdba_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 fromdba_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 fromdba_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 fromdba_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 fromdba_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.