当前位置:Gxlcms > mysql > Oracle解锁与加锁(hr用户为例)

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

时间:2021-07-01 10:21:17 帮助过:88人阅读

欢迎进入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.

人气教程排行