>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on 星期日 10月 16 08:08:45 2011Copyright (c) 1982, 2010, Oracle. All rights reserved.连接到:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> desc dba_users; ####描述dba_users 名称 是否为空? 类型 ----------------------------------------- -------- ---------------------------- 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) PASSWORD_VERSIONS VARCHAR2(8) EDITIONS_ENABLED VARCHAR2(1) AUTHENTICATION_TYPE VARCHAR2(8)SQL> select username, account_status from dba_users order by username;USERNAME ACCOUNT_STATUS------------------------------ --------------------------------ANONYMOUS EXPIRED & LOCKEDAPEX_030200 EXPIRED & LOCKEDAPEX_PUBLIC_USER EXPIRED & LOCKEDAPPQOSSYS EXPIRED & LOCKEDBI EXPIRED & LOCKEDCTXSYS EXPIRED & LOCKEDDBSNMP OPENDIP EXPIRED & LOCKEDEXFSYS EXPIRED & LOCKEDFLOWS_FILES EXPIRED & LOCKED*HR EXPIRED & LOCKED* ###此时hr状态为过期并且锁住USERNAME ACCOUNT_STATUS------------------------------ --------------------------------IX EXPIRED & LOCKEDMDDATA EXPIRED & LOCKEDMDSYS EXPIRED & LOCKEDMGMT_VIEW OPENOE EXPIRED & LOCKEDOLAPSYS EXPIRED & LOCKEDORACLE_OCM EXPIRED & LOCKEDORDDATA EXPIRED & LOCKEDORDPLUGINS EXPIRED & LOCKEDORDSYS EXPIRED & LOCKEDOUTLN EXPIRED & LOCKEDUSERNAME ACCOUNT_STATUS------------------------------ --------------------------------OWBSYS EXPIRED & LOCKEDOWBSYS_AUDIT EXPIRED & LOCKEDPM EXPIRED & LOCKEDSCOTT OPENSH EXPIRED & LOCKEDSI_INFORMTN_SCHEMA EXPIRED & LOCKEDSPATIAL_CSW_ADMIN_USR EXPIRED & LOCKEDSPATIAL_WFS_ADMIN_USR EXPIRED & LOCKEDSYS OPENSYSMAN OPENSYSTEM OPENUSERNAME ACCOUNT_STATUS------------------------------ --------------------------------WMSYS EXPIRED & LOCKEDXDB EXPIRED & LOCKEDXS$NULL EXPIRED & LOCKED已选择36行。SQL> *alter user hr account unlock;* ####更改用户hr帐户为未锁用户已更改。SQL> select username, account_status from dba_users order by username;USERNAME ACCOUNT_STATUS------------------------------ --------------------------------ANONYMOUS EXPIRED & LOCKEDAPEX_030200 EXPIRED & LOCKEDAPEX_PUBLIC_USER EXPIRED & LOCKEDAPPQOSSYS EXPIRED & LOCKEDBI EXPIRED & LOCKEDCTXSYS EXPIRED & LOCKEDDBSNMP OPENDIP EXPIRED & LOCKEDEXFSYS EXPIRED & LOCKEDFLOWS_FILES EXPIRED & LOCKED*HR EXPIRED* ####此时hr只是过期并没有被锁住USERNAME ACCOUNT_STATUS------------------------------ --------------------------------IX EXPIRED & LOCKEDMDDATA EXPIRED & LOCKEDMDSYS EXPIRED & LOCKEDMGMT_VIEW OPENOE EXPIRED & LOCKEDOLAPSYS EXPIRED & LOCKEDORACLE_OCM EXPIRED & LOCKEDORDDATA EXPIRED & LOCKEDORDPLUGINS EXPIRED & LOCKEDORDSYS EXPIRED & LOCKEDOUTLN EXPIRED & LOCKEDUSERNAME ACCOUNT_STATUS------------------------------ --------------------------------OWBSYS EXPIRED & LOCKEDOWBSYS_AUDIT EXPIRED & LOCKEDPM EXPIRED & LOCKEDSCOTT OPENSH EXPIRED & LOCKEDSI_INFORMTN_SCHEMA EXPIRED & LOCKEDSPATIAL_CSW_ADMIN_USR EXPIRED & LOCKEDSPATIAL_WFS_ADMIN_USR EXPIRED & LOCKEDSYS OPENSYSMAN OPENSYSTEM OPENUSERNAME ACCOUNT_STATUS------------------------------ --------------------------------WMSYS EXPIRED & LOCKEDXDB EXPIRED & LOCKEDXS$NULL EXPIRED & LOCKED已选择36行。SQL> *alter user hr identified by hr;* ####更改用户hr的密码为hr用户已更改。SQL> select username, account_status from dba_users order by username;USERNAME ACCOUNT_STATUS------------------------------ --------------------------------ANONYMOUS EXPIRED & LOCKEDAPEX_030200 EXPIRED & LOCKEDAPEX_PUBLIC_USER EXPIRED & LOCKEDAPPQOSSYS EXPIRED & LOCKEDBI EXPIRED & LOCKEDCTXSYS EXPIRED & LOCKEDDBSNMP OPENDIP EXPIRED & LOCKEDEXFSYS EXPIRED & LOCKEDFLOWS_FILES EXPIRED & LOCKED*HR OPEN* ####此时hr状态为OPENUSERNAME ACCOUNT_STATUS------------------------------ --------------------------------IX EXPIRED & LOCKEDMDDATA EXPIRED & LOCKEDMDSYS EXPIRED & LOCKEDMGMT_VIEW OPENOE EXPIRED & LOCKEDOLAPSYS EXPIRED & LOCKEDORACLE_OCM EXPIRED & LOCKEDORDDATA EXPIRED & LOCKEDORDPLUGINS EXPIRED & LOCKEDORDSYS EXPIRED & LOCKEDOUTLN EXPIRED & LOCKEDUSERNAME ACCOUNT_STATUS------------------------------ --------------------------------OWBSYS EXPIRED & LOCKEDOWBSYS_AUDIT EXPIRED & LOCKEDPM EXPIRED & LOCKEDSCOTT OPENSH EXPIRED & LOCKEDSI_INFORMTN_SCHEMA EXPIRED & LOCKEDSPATIAL_CSW_ADMIN_USR EXPIRED & LOCKEDSPATIAL_WFS_ADMIN_USR EXPIRED & LOCKEDSYS OPENSYSMAN OPENSYSTEM OPENUSERNAME ACCOUNT_STATUS------------------------------ --------------------------------WMSYS EXPIRED & LOCKEDXDB EXPIRED & LOCKEDXS$NULL EXPIRED & LOCKED已选择36行。SQL> conn hr/hr ####以hr帐户登陆已连接。SQL> show user;USER 为 "HR"