본문 바로가기

broko Blog!

[oracle] user lock/unlock 하기

반응형

SQL> ALTER USER username ACCOUNT LOCK;

SQL> ALTER USER username ACCOUNT UNLOCK;
ex)
SQL> ALTER USER scott ACCOUNT LOCK;
SQL> ALTER USER scott ACCOUNT UNLOCK;