Oracle解锁与加锁（hr用户为例）

欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入 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 u

欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入

　　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.