给自己提了个问题，顺手验证了一把

[@more@]

1、以scott账户登录

SQL> conn scott/tiger
Connected.
SQL>
SQL>
SQL>
SQL> show user;
USER is "SCOTT"
SQL>
SQL> select * from dual;

D
-
X

2、另起一个sqlplus窗口
SQL> conn / as sysdba
SQL> alter user scott account lock;

SQL> alter user scott account lock;

User altered.

SQL> conn scott/tiger
ERROR:
ORA-28000: the account is locked

Warning: You are no longer connected to ORACLE.

3、返回原先的sqlplus窗口

SQL> select * from dual;

D
-
X

ITPub博客

数据库用户被lock，不影响当前已连接的session