人的差别在于业余时间,而一个人的命运决定于晚上8点到10点之间。 北京安全测试精英QQ群:164265622 北京白盒测试精英QQ群:164265999 北京性能测试精英QQ群:164266156 北京自动化测试精英群:212723528 北京软件测试精英QQ群:86920845

Oracle的解锁与加锁(hr用户为例)

上一篇 / 下一篇  2012-04-04 10:18:57 / 个人分类:性能测试



    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.

TAG:

 

评分:0

我来说两句

Open Toolbar