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

php中文网
发布: 2016-06-07 15:15:01
原创
1321人浏览过

欢迎进入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.

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

最佳 Windows 性能的顶级免费优化软件
最佳 Windows 性能的顶级免费优化软件

每个人都需要一台速度更快、更稳定的 PC。随着时间的推移,垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是,许多工具可以让 Windows 保持平稳运行。

下载
相关标签:
来源:php中文网
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
最新问题
开源免费商场系统广告
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板
关于我们 免责申明 意见反馈 讲师合作 广告合作 最新更新
php中文网:公益在线php培训,帮助PHP学习者快速成长!
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送
PHP中文网APP
随时随地碎片化学习
PHP中文网抖音号
发现有趣的

Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号