Oracle数据库的解锁与加锁(hr用户为例)_Oracle数据库_黑客防线网安服务器维护基地--Powered by WWW.RONGSEN.COM.CN

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

作者:黑客防线网安Oracle维护基地 来源:黑客防线网安Oracle维护基地 浏览次数:0

本篇关键词:Oracle数据库Oracle教程
黑客防线网安网讯:    SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jul 14 18:12:38 2009Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.SQL> conn sys/sys as sysdbaConnected....
    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.
    黑客防线网安服务器维护方案本篇连接:http://www.rongsen.com.cn/show-13202-1.html
网站维护教程更新时间:2012-03-23 00:52:14  【打印此页】  【关闭
我要申请本站N点 | 黑客防线官网 |  
专业服务器维护及网站维护手工安全搭建环境,网站安全加固服务。黑客防线网安服务器维护基地招商进行中!QQ:29769479

footer  footer  footer  footer