對這文章發表回應
發表限制: 非會員 可以發表
發表者: 冷日 發表時間: 2019/3/22 11:55:20
How to Unlock the Account in Oracle
Steps
- 1Find which accounts are locked with the following query.
- SQL > select username,account_status from dba_users where account_status like '%LOCK%';
- USERNAME ACCOUNT_STATUS
- ------------------------------ ----------------
- OUTLN EXPIRED & LOCKED
- MDSYS EXPIRED & LOCKED
- MDDATA EXPIRED & LOCKED
- 2Unlock the user with the following command.
- SQL > alter user MDDATA account unlock; User altered.
原文出處:How to Unlock the Account in Oracle: 2 Steps (with Pictures)