我在9i中的实验表明:sys用户即使被锁定,也是可以登陆的,而其它用户如system则不行。
1、 SYS 用户
SQL> ALTER USER SYS ACCOUNT LOCK;
用户已更改。
SQL> CONN SYS/PRACTICE AS SYSDBA
已连接。
SQL> select username,account_status from dba_users where username='SYS';
USERNAME
ACCOUNT_STATUS
------------------------------ --------------------------------
SYS
LOCKED//锁定状态
2、system用户
SQL> ALTER USER SYSTEM ACCOUNT LOCK;
用户已更改。
SQL> conn system/manager
ERROR:
ORA-28000: the account is locked
警告: 您不再连接到 ORACLE。
SQL> CONN SYS/PRACTICE AS SYSDBA
已连接。
SQL> select username,account_status from dba_users where username='SYSTEM';
USERNAME
ACCOUNT_STATUS
------------------------------ --------------------------------
SYSTEM
LOCKED//锁定状态
SQL> conn / assysdba
Connected.
SQL> alter user sys account lock;
User altered.
SQL> conn sys/rainy
ERROR:
ORA-28000: the account is locked
Warning: You are no longer connected to ORACLE.
SQL> conn sys/rainy as sysdba
Connected.
SQL> alter user sys account unlock;
User altered.
SQL> conn sys/rainy
Connected.
人家上面已经做了演示了!
我还能说什么呢?
SQL>