[oracle@jieshi9i ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jul 14 18:12:382009
Copyright (c) 1982, 2002, Oracle Corporation.
SQL> conn /as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> desc dba_users
SQL> set lines 200
SQL> select username,account_status fromdba_users;
USERNAME
--------------------------------------------------------------
SYS
SYSTEM
DBSNMP
SCOTT
OUTLN
WMSYS
ORDSYS
ORDPLUGINS
MDSYS
CTXSYS
XDB
USERNAME
--------------------------------------------------------------
ANONYMOUS
WKSYS
WKPROXY
ODM
ODM_MTR
OLAPSYS
HR
OE
PM
SQL> alter user hr account unlock;(解锁)
User altered.
SQL> select username,account_status fromdba_users;
USERNAME
--------------------------------------------------------------
SYS
SYSTEM
DBSNMP
SCOTT
HR
OUTLN
WMSYS
ORDSYS
ORDPLUGINS
QL> alter user hr identified by hr;(更改密码)
User altered.
SQL> select username,account_status fromdba_users;
USERNAME
--------------------------------------------------------------
SYS
SYSTEM
DBSNMP
SCOTT
HR
OUTLN
SQL> conn hr/hr
Connected.
SQL> conn /as sysdba
Connected.
SQL> alter user hr account lock;(加锁)
User altered.
SQL> select username,account_status fromdba_users;
USERNAME
--------------------------------------------------------------
SYS
SYSTEM
DBSNMP
SCOTT
HR
OUTLN
SQL> alter user hr password expire;(密码失效)
User altered.
SQL> select username,account_status fromdba_users;
USERNAME
--------------------------------------------------------------
SYS
SYSTEM
DBSNMP
SCOTT
OUTLN
WMSYS
OLAPSYS
HR
OE
PM
SQL> conn hr/hr
ERROR:
ORA-28000: the account is locked
Warning: You are no longer connected to ORACLE.