对用户加锁/解锁

查看账户状态：
SQL> select username,account_status from dba_users where username='SCOTT';

对用户加锁
SQL> alter user scott account lock;

给用户解锁
SQL> alter user scott account unlock;


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

///////////////////
//先看一下当前用户是什么，看看他是否有权限去锁定和解锁账户
//////////////////
SQL> show user;
USER 为 "SYS"

///////////////////
//先看一下SCOTT用户当前的账户状态
//////////////////
SQL> select username,account_status from dba_users where username='SCOTT';
USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
SCOTT                          OPEN

///////////////////
//对SCOTT用户加锁
//////////////////
SQL> alter user scott account lock;
用户已更改。

SQL> select username,account_status from dba_users where username='SCOTT';
USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
SCOTT                          LOCKED

///////////////////
//对SCOTT用户解锁
//////////////////
SQL> alter user scott account unlock;
用户已更改。

SQL> select username,account_status from dba_users where username='SCOTT';
USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
SCOTT                          OPEN
SQL>
------------------------------

以上。