>sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on 星期日 10月 16 08:08:45 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. 连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> 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 & LOCKED APEX_030200 EXPIRED & LOCKED APEX_PUBLIC_USER EXPIRED & LOCKED APPQOSSYS EXPIRED & LOCKED BI EXPIRED & LOCKED CTXSYS EXPIRED & LOCKED DBSNMP OPEN DIP EXPIRED & LOCKED EXFSYS EXPIRED & LOCKED FLOWS_FILES EXPIRED & LOCKED *HR EXPIRED & LOCKED* ###此时hr状态为过期并且锁住 USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- IX EXPIRED & LOCKED MDDATA EXPIRED & LOCKED MDSYS EXPIRED & LOCKED MGMT_VIEW OPEN OE EXPIRED & LOCKED OLAPSYS EXPIRED & LOCKED ORACLE_OCM EXPIRED & LOCKED ORDDATA EXPIRED & LOCKED ORDPLUGINS EXPIRED & LOCKED ORDSYS EXPIRED & LOCKED OUTLN EXPIRED & LOCKED USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- OWBSYS EXPIRED & LOCKED OWBSYS_AUDIT EXPIRED & LOCKED PM EXPIRED & LOCKED SCOTT OPEN SH EXPIRED & LOCKED SI_INFORMTN_SCHEMA EXPIRED & LOCKED SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED SYS OPEN SYSMAN OPEN SYSTEM OPEN USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- WMSYS EXPIRED & LOCKED XDB EXPIRED & LOCKED XS$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 & LOCKED APEX_030200 EXPIRED & LOCKED APEX_PUBLIC_USER EXPIRED & LOCKED APPQOSSYS EXPIRED & LOCKED BI EXPIRED & LOCKED CTXSYS EXPIRED & LOCKED DBSNMP OPEN DIP EXPIRED & LOCKED EXFSYS EXPIRED & LOCKED FLOWS_FILES EXPIRED & LOCKED *HR EXPIRED* ####此时hr只是过期并没有被锁住 USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- IX EXPIRED & LOCKED MDDATA EXPIRED & LOCKED MDSYS EXPIRED & LOCKED MGMT_VIEW OPEN OE EXPIRED & LOCKED OLAPSYS EXPIRED & LOCKED ORACLE_OCM EXPIRED & LOCKED ORDDATA EXPIRED & LOCKED ORDPLUGINS EXPIRED & LOCKED ORDSYS EXPIRED & LOCKED OUTLN EXPIRED & LOCKED USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- OWBSYS EXPIRED & LOCKED OWBSYS_AUDIT EXPIRED & LOCKED PM EXPIRED & LOCKED SCOTT OPEN SH EXPIRED & LOCKED SI_INFORMTN_SCHEMA EXPIRED & LOCKED SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED SYS OPEN SYSMAN OPEN SYSTEM OPEN USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- WMSYS EXPIRED & LOCKED XDB EXPIRED & LOCKED XS$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 & LOCKED APEX_030200 EXPIRED & LOCKED APEX_PUBLIC_USER EXPIRED & LOCKED APPQOSSYS EXPIRED & LOCKED BI EXPIRED & LOCKED CTXSYS EXPIRED & LOCKED DBSNMP OPEN DIP EXPIRED & LOCKED EXFSYS EXPIRED & LOCKED FLOWS_FILES EXPIRED & LOCKED *HR OPEN* ####此时hr状态为OPEN USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- IX EXPIRED & LOCKED MDDATA EXPIRED & LOCKED MDSYS EXPIRED & LOCKED MGMT_VIEW OPEN OE EXPIRED & LOCKED OLAPSYS EXPIRED & LOCKED ORACLE_OCM EXPIRED & LOCKED ORDDATA EXPIRED & LOCKED ORDPLUGINS EXPIRED & LOCKED ORDSYS EXPIRED & LOCKED OUTLN EXPIRED & LOCKED USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- OWBSYS EXPIRED & LOCKED OWBSYS_AUDIT EXPIRED & LOCKED PM EXPIRED & LOCKED SCOTT OPEN SH EXPIRED & LOCKED SI_INFORMTN_SCHEMA EXPIRED & LOCKED SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED SYS OPEN SYSMAN OPEN SYSTEM OPEN USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- WMSYS EXPIRED & LOCKED XDB EXPIRED & LOCKED XS$NULL EXPIRED & LOCKED 已选择36行。 SQL> conn hr/hr ####以hr帐户登陆 已连接。 SQL> show user; USER 为 "HR"
转载于:https://www.cnblogs.com/visayafan/archive/2011/10/16/2214296.html