Oracle解锁与加锁（hr用户为例）
[oracle@jieshi9i ~]$ sqlplus /nolog
SQL*Plus: Relea 9.2.0.4.0 - Production on Tue Jul 14 18:12:38 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights rerved.
SQL> conn sys/sys as sysdba
Connected.
SQL> show ur
USER is "SYS"
SQL> desc dba_urs
Name Null? Type
----------------------------------------- -------- ----------------------------
USERNAME NOT NULL VARCHAR2(30)
USER_ID NOT NULL NUMBER
reply
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)
customizeINITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30)
EXTERNAL_NAME VARCHAR2(4000)
SQL> t lines 200
SQL> lect urname,account_status from dba_urs;
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
ielts考试
ODM_MTR EXPIRED & LOCKED
OLAPSYS EXPIRED & LOCKED
HR EXPIRED & LOCKED
OE EXPIRED & LOCKED
PM EXPIRED & LOCKED
先考托福还是gmat SQL> alter ur hr account unlock;（解锁）
Ur altered.
SQL> lect urname,account_status from dba_urs;
情侣网名 英文USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
SCOTT OPEN
HR EXPIRED
OUTLN EXPIRED & LOCKED
WMSYS EXPIRED & LOCKED
ORDSYS EXPIRED & LOCKED
insideoutORDPLUGINS EXPIRED & LOCKED
QL> alter ur hr identified by hr;（更改密码）
Ur altered.
SQL> lect urname,account_status from dba_urs;
USERNAME ACCOUNT_STATUS
t out ------------------------------ --------------------------------
scigen SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
SCOTT OPEN
HR OPENcancel
OUTLN EXPIRED & LOCKED
SQL> conn hr/hr
Connected.
SQL> conn /as sysdba
Connected.
SQL> alter ur hr account lock;（加锁）
Ur altered.
SQL> lect urname,account_status from dba_urs;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
SCOTT OPEN
HR LOCKED
OUTLN EXPIRED & LOCKED
SQL> alter ur hr password expire;（密码失效）
Ur altered.
SQL> lect urname,account_status from dba_urs;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
