[SYS@myorcl] SQL>alter user test account lock;用户已更改。[SYS@myorcl] SQL>SELECT T.USERNAME, T.ACCOUNT_STATUS 2 FROM DBA_USERS T 3 WHERE T.USERNAME = 'TEST';USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- TEST LOCKED[SYS@myorcl] SQL> [SYS@myorcl] SQL>conn test/test ERROR: ORA-28000: the account is locked --这里就是锁与不锁的区别 警告: 您不再连接到 ORACLE。 [@] SQL>conn / as sysdba 已连接。 [SYS@myorcl] SQL>alter user test account unlock;用户已更改。[SYS@myorcl] SQL>SELECT T.USERNAME, T.ACCOUNT_STATUS 2 FROM DBA_USERS T 3 WHERE T.USERNAME = 'TEST';USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- TEST OPEN[SYS@myorcl] SQL> [SYS@myorcl] SQL>conn test/test 已连接。 [TEST@myorcl] SQL>
[SYS@myorcl] SQL>alter user test account lock;用户已更改。[SYS@myorcl] SQL>SELECT T.USERNAME, T.ACCOUNT_STATUS
2 FROM DBA_USERS T
3 WHERE T.USERNAME = 'TEST';USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
TEST LOCKED[SYS@myorcl] SQL>
[SYS@myorcl] SQL>conn test/test
ERROR:
ORA-28000: the account is locked --这里就是锁与不锁的区别
警告: 您不再连接到 ORACLE。
[@] SQL>conn / as sysdba
已连接。
[SYS@myorcl] SQL>alter user test account unlock;用户已更改。[SYS@myorcl] SQL>SELECT T.USERNAME, T.ACCOUNT_STATUS
2 FROM DBA_USERS T
3 WHERE T.USERNAME = 'TEST';USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
TEST OPEN[SYS@myorcl] SQL>
[SYS@myorcl] SQL>conn test/test
已连接。
[TEST@myorcl] SQL>