欢迎进入oracle社区论坛，与200万技术人员互动交流 >>进入 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 u
欢迎进入oracle社区论坛，与200万技术人员互动交流 >>进入
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.