Oracle 用户加锁与解锁,ORACLE--用户加锁和解锁--2012-12-18

1、给数据库用户加锁：

SQL> conn / as sysdba

已连接。

SQL> alter user wangyongke account lock;

用户已更改。

2、测试加锁是否成功：

SQL> conn wangyongke/w123123

ERROR:

ORA-28000: the account is locked

警告: 您不再连接到 ORACLE。

3、用户解锁：

SQL> alter user wangyongke account unlock;

用户已更改。

4、测试解锁：

SQL> conn wangyongke/w123123

已连接。

5、是否是解锁用户：

SQL> sho user

USER 为 "WANGYONGKE"

SQL>

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

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.