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.
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 没有源码,如何修改代码逻辑?
· PowerShell开发游戏 · 打蜜蜂
· 在鹅厂做java开发是什么体验
· 百万级群聊的设计实践
· WPF到Web的无缝过渡:英雄联盟客户端的OpenSilver迁移实战