Oracle为用户解锁

时间:2016-08-22
简介:数据库|首先先连接上SQL*Plus: Release 12.1.0.2.0 Production on 星期四 2月 12 15:40:422015Copyright

首先先连接上

SQL*Plus: Release 12.1.0.2.0 Production on 星期四 2月 12 15:40:422015
Copyright (c) 1982, 2014, Oracle.  All rights reserved.
请输入用户名:  system
输入口令:
上次成功登录时间: 星期四 2月  12 2015 10:26:40 +08:00
连接到:
Oracle Database 12c Enterprise EditionRelease 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, AdvancedAnalytics and Real Application Testing opt
Ions
//对相应的列惊醒格式化操作,以便观察
SQL> column username format a20
SQL> column account_status format a20
SQL> set pagesize 400
//输入下面这条select语句,从dba_users查询用户以及状态信息
SQL> select username,account_status fromdba_users
USERNAME            ACCOUNT_STATUS
-------------------- --------------------
C##TEST              OPEN
C##SCOTT             OPEN
ORACLE_OCM           EXPIRED & LOCKED
OJVMSYS              EXPIRED & LOCKED
SYSKM                EXPIRED & LOCKED
XS$NULL              EXPIRED & LOCKED
GSMCATUSER           EXPIRED & LOCKED
MDDATA               EXPIRED & LOCKED
SYSBACKUP            EXPIRED & LOCKED
DIP                  EXPIRED & LOCKED
SYSDG                EXPIRED & LOCKED
APEX_PUBLIC_USER     EXPIRED & LOCKED
SPATIAL_CSW_ADMIN_US EXPIRED & LOCKED
R
 
SPATIAL_WFS_ADMIN_US EXPIRED & LOCKED
R
 
GSMUSER              EXPIRED & LOCKED
AUDSYS                EXPIRED& LOCKED
C##USER1              OPEN
FLOWS_FILES           EXPIRED& LOCKED
DVF                   EXPIRED & LOCKED
MDSYS                 EXPIRED& LOCKED
ORDSYS                EXPIRED& LOCKED
DBSNMP               EXPIRED & LOCKED
WMSYS                EXPIRED & LOCKED
APEX_040200          EXPIRED & LOCKED
APPQOSSYS            EXPIRED & LOCKED
GSMADMIN_INTERNAL    EXPIRED & LOCKED
ORDDATA              EXPIRED & LOCKED
CTXSYS               EXPIRED & LOCKED
ANONYMOUS            EXPIRED & LOCKED
XDB                  EXPIRED & LOCKED
ORDPLUGINS           EXPIRED & LOCKED
DVSYS                EXPIRED & LOCKED
SI_INFORMTN_SCHEMA   EXPIRED & LOCKED
OLAPSYS              EXPIRED & LOCKED
LBACSYS              EXPIRED & LOCKED
OUTLN                EXPIRED & LOCKED
SYSTEM               OPEN
SYS                 OPEN
已选择 38 行。
如上面所示,如果username对应的account_status为open,表示该用户解锁, 如果username对应的account_status为EXPIRED,表示该用户已经过期,如果username对应的account_status为locked,表示该用户锁定。使用过期的或者锁定的账号是登陆不上的,我们必须先对用户解锁。
//接下来我们对outln用户进行解锁
SQL> alter user outln account unlock;
用户已更改。
//给该用户指定口令
SQL> alter user outln identified byadmin;
用户已更改。
//我们再查询所用用户
SQL> select username,account_status fromdba_users;
USERNAME             ACCOUNT_STATUS
-------------------- --------------------
C##TEST              OPEN
C##SCOTT             OPEN
ORACLE_OCM           EXPIRED & LOCKED
OJVMSYS              EXPIRED & LOCKED
SYSKM                EXPIRED & LOCKED
XS$NULL              EXPIRED & LOCKED
GSMCATUSER           EXPIRED & LOCKED
MDDATA               EXPIRED & LOCKED
SYSBACKUP            EXPIRED & LOCKED
DIP                  EXPIRED & LOCKED
SYSDG                EXPIRED & LOCKED
APEX_PUBLIC_USER     EXPIRED & LOCKED
SPATIAL_CSW_ADMIN_US EXPIRED & LOCKED
R
SPATIAL_WFS_ADMIN_US EXPIRED & LOCKED
R
GSMUSER              EXPIRED & LOCKED
AUDSYS               EXPIRED & LOCKED
C##USER1             OPEN
FLOWS_FILES          EXPIRED & LOCKED
DVF                  EXPIRED & LOCKED
MDSYS                EXPIRED & LOCKED
ORDSYS               EXPIRED & LOCKED
DBSNMP               EXPIRED & LOCKED
WMSYS                EXPIRED & LOCKED
APEX_040200          EXPIRED & LOCKED
APPQOSSYS            EXPIRED & LOCKED
GSMADMIN_INTERNAL    EXPIRED & LOCKED
ORDDATA              EXPIRED & LOCKED
CTXSYS               EXPIRED & LOCKED
ANONYMOUS            EXPIRED & LOCKED
XDB                  EXPIRED & LOCKED
ORDPLUGINS           EXPIRED & LOCKED
DVSYS                EXPIRED & LOCKED
SI_INFORMTN_SCHEMA   EXPIRED & LOCKED
OLAPSYS              EXPIRED & LOCKED
LBACSYS              EXPIRED & LOCKED
OUTLN                OPEN
SYSTEM               OPEN
SYS                  OPEN
已选择 38 行。
如上,outln已经显示为open。
//测试连接
SQL> connect outln/admin
已连接。

TAGS:Oracle用户解锁

上一编:Oracle包的使用教程

下一编:oracle日期类型数据的插入操作

ab蓝学网|IT技术学习网站
Copyright (C) 2016 www.ablanxue.com, All Rights Reserved.ab蓝学网 IT技术长尾词 New article Hot article