oracle 为 用户 解锁 加锁 (以hr为例)
来源:互联网 发布:手写笔 软件 编辑:程序博客网 时间:2024/05/24 15:40
oracle 为 用户 解锁 加锁 (以hr为例)
>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on 星期日 10月 16 08:08:45 2011Copyright (c) 1982, 2010, Oracle. All rights reserved.连接到:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> desc dba_users; ####描述dba_users
可能会报错:
ORA-01012: not logged on
解决办法:重新打开数据库SQL>startup名称 是否为空? 类型 ----------------------------------------- -------- ---------------------------- 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) PASSWORD_VERSIONS VARCHAR2(8) EDITIONS_ENABLED VARCHAR2(1) AUTHENTICATION_TYPE VARCHAR2(8)SQL> select username, account_status from dba_users order by username;USERNAME ACCOUNT_STATUS------------------------------ --------------------------------ANONYMOUS EXPIRED & LOCKEDAPEX_030200 EXPIRED & LOCKEDAPEX_PUBLIC_USER EXPIRED & LOCKEDAPPQOSSYS EXPIRED & LOCKEDBI EXPIRED & LOCKEDCTXSYS EXPIRED & LOCKEDDBSNMP OPENDIP EXPIRED & LOCKEDEXFSYS EXPIRED & LOCKEDFLOWS_FILES EXPIRED & LOCKED*HR EXPIRED & LOCKED* ###此时hr状态为过期并且锁住USERNAME ACCOUNT_STATUS------------------------------ --------------------------------IX EXPIRED & LOCKEDMDDATA EXPIRED & LOCKEDMDSYS EXPIRED & LOCKEDMGMT_VIEW OPENOE EXPIRED & LOCKEDOLAPSYS EXPIRED & LOCKEDORACLE_OCM EXPIRED & LOCKEDORDDATA EXPIRED & LOCKEDORDPLUGINS EXPIRED & LOCKEDORDSYS EXPIRED & LOCKEDOUTLN EXPIRED & LOCKEDUSERNAME ACCOUNT_STATUS------------------------------ --------------------------------OWBSYS EXPIRED & LOCKEDOWBSYS_AUDIT EXPIRED & LOCKEDPM EXPIRED & LOCKEDSCOTT OPENSH EXPIRED & LOCKEDSI_INFORMTN_SCHEMA EXPIRED & LOCKEDSPATIAL_CSW_ADMIN_USR EXPIRED & LOCKEDSPATIAL_WFS_ADMIN_USR EXPIRED & LOCKEDSYS OPENSYSMAN OPENSYSTEM OPENUSERNAME ACCOUNT_STATUS------------------------------ --------------------------------WMSYS EXPIRED & LOCKEDXDB EXPIRED & LOCKEDXS$NULL EXPIRED & LOCKED已选择36行。SQL> *alter user hr account unlock;* ####更改用户hr帐户为未锁用户已更改。SQL> select username, account_status from dba_users order by username;USERNAME ACCOUNT_STATUS------------------------------ --------------------------------ANONYMOUS EXPIRED & LOCKEDAPEX_030200 EXPIRED & LOCKEDAPEX_PUBLIC_USER EXPIRED & LOCKEDAPPQOSSYS EXPIRED & LOCKEDBI EXPIRED & LOCKEDCTXSYS EXPIRED & LOCKEDDBSNMP OPENDIP EXPIRED & LOCKEDEXFSYS EXPIRED & LOCKEDFLOWS_FILES EXPIRED & LOCKED*HR EXPIRED* ####此时hr只是过期并没有被锁住USERNAME ACCOUNT_STATUS------------------------------ --------------------------------IX EXPIRED & LOCKEDMDDATA EXPIRED & LOCKEDMDSYS EXPIRED & LOCKEDMGMT_VIEW OPENOE EXPIRED & LOCKEDOLAPSYS EXPIRED & LOCKEDORACLE_OCM EXPIRED & LOCKEDORDDATA EXPIRED & LOCKEDORDPLUGINS EXPIRED & LOCKEDORDSYS EXPIRED & LOCKEDOUTLN EXPIRED & LOCKEDUSERNAME ACCOUNT_STATUS------------------------------ --------------------------------OWBSYS EXPIRED & LOCKEDOWBSYS_AUDIT EXPIRED & LOCKEDPM EXPIRED & LOCKEDSCOTT OPENSH EXPIRED & LOCKEDSI_INFORMTN_SCHEMA EXPIRED & LOCKEDSPATIAL_CSW_ADMIN_USR EXPIRED & LOCKEDSPATIAL_WFS_ADMIN_USR EXPIRED & LOCKEDSYS OPENSYSMAN OPENSYSTEM OPENUSERNAME ACCOUNT_STATUS------------------------------ --------------------------------WMSYS EXPIRED & LOCKEDXDB EXPIRED & LOCKEDXS$NULL EXPIRED & LOCKED已选择36行。SQL> *alter user hr identified by hr;* ####更改用户hr的密码为hr用户已更改。SQL> select username, account_status from dba_users order by username;USERNAME ACCOUNT_STATUS------------------------------ --------------------------------ANONYMOUS EXPIRED & LOCKEDAPEX_030200 EXPIRED & LOCKEDAPEX_PUBLIC_USER EXPIRED & LOCKEDAPPQOSSYS EXPIRED & LOCKEDBI EXPIRED & LOCKEDCTXSYS EXPIRED & LOCKEDDBSNMP OPENDIP EXPIRED & LOCKEDEXFSYS EXPIRED & LOCKEDFLOWS_FILES EXPIRED & LOCKED*HR OPEN* ####此时hr状态为OPENUSERNAME ACCOUNT_STATUS------------------------------ --------------------------------IX EXPIRED & LOCKEDMDDATA EXPIRED & LOCKEDMDSYS EXPIRED & LOCKEDMGMT_VIEW OPENOE EXPIRED & LOCKEDOLAPSYS EXPIRED & LOCKEDORACLE_OCM EXPIRED & LOCKEDORDDATA EXPIRED & LOCKEDORDPLUGINS EXPIRED & LOCKEDORDSYS EXPIRED & LOCKEDOUTLN EXPIRED & LOCKEDUSERNAME ACCOUNT_STATUS------------------------------ --------------------------------OWBSYS EXPIRED & LOCKEDOWBSYS_AUDIT EXPIRED & LOCKEDPM EXPIRED & LOCKEDSCOTT OPENSH EXPIRED & LOCKEDSI_INFORMTN_SCHEMA EXPIRED & LOCKEDSPATIAL_CSW_ADMIN_USR EXPIRED & LOCKEDSPATIAL_WFS_ADMIN_USR EXPIRED & LOCKEDSYS OPENSYSMAN OPENSYSTEM OPENUSERNAME ACCOUNT_STATUS------------------------------ --------------------------------WMSYS EXPIRED & LOCKEDXDB EXPIRED & LOCKEDXS$NULL EXPIRED & LOCKED已选择36行。SQL> conn hr/hr ####以hr帐户登陆已连接。SQL> show user;USER 为 "HR"SQL> desc dba_users;
0 0
- oracle 为 用户 解锁 加锁 (以hr为例)
- Oracle解锁与加锁(hr用户为例)
- Oracle解锁与加锁(hr用户为例)
- oracle为hr用户解锁,添加scott用户
- oracle 11g 安装之后如何为用户解锁、加锁
- 为oracle 11g hr用户解锁并修改密码
- oracle用户解锁/加锁
- oracle用户解锁与加锁
- Oracle 用户加锁与解锁
- 修改oracle数据库用户名称和密码,数据库用户锁定、解锁(Linux为例)
- oracle数据库用户加锁和解锁
- 给oracle数据库用户加锁和解锁
- oracle数据库用户加锁和解锁
- Oracle hr 用户解锁, 并改密码
- Oracle hr用户解锁,并修改密码
- Oracle 为数据表解锁
- 安装oracle数据库后为Scott用户解锁
- 为oracle自带的scott用户解锁
- ssh免密码登陆
- InstallShield 2013 应用笔记(一)
- sql sever 三种分页方式效率的简单测试
- SublimeText3安装Package Control
- 如何让自己变得更优质?
- oracle 为 用户 解锁 加锁 (以hr为例)
- sgu-242 Student's Morning
- clamav病毒库格式解析
- Operating SystemVersion NumberOther Information
- 韩顺平老师《一周学会Linux》视频笔记
- Leetcode 编程训练 (转)
- 欢迎使用CSDN-markdown编辑器
- 省赛总结(2015)
- servlet开发6-接收用户提交的表单数据