安装oracle是怎么解锁hr用户,Oracle的解锁与加锁（hr用户为例）

Oracle的解锁与加锁(hr用户为例)

上一篇 /

下一篇  2012-04-04 10:18:57

/ 个人分类：性能测试

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                        EX