excel平均值公式
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
PASSWORD VARCHAR2(30)
ACCOUNT_STATUS NOT NULL VARCHAR2(32)
12星座高跟鞋
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> 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
ODM_MTR EXPIRED & LOCKED
OLAPSYS EXPIRED & LOCKED
HR EXPIRED & LOCKED
OE EXPIRED & LOCKED
PM EXPIRED & LOCKED
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
ORDPLUGINS EXPIRED & LOCKED
QL> alter ur hr identified by hr;（更改密码）
Ur altered.
SQL> lect urname,account_status from dba_urs;
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 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
