Oracle解鎖與加鎖（hr使用者為例）

Oracle解鎖與加鎖（hr使用者為例）

 

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.

 

已投稿到：

 圈子