Java tips, observations, bugs and problems from the world of Spring, Weblogic, Oracle, MySQL and many other technologies...
Thursday, 13 January 2011
Unlocking an Oracle Database Account
This is a small but useful thing to know... often because you’ve type the wrong password into a configuration file that then locks you out of the database because you try to connect and fail – lots of times...
So here's how to lock or unlock Oracle database user accounts.
SQL> ALTER USER username ACCOUNT LOCK;
SQL> ALTER USER username ACCOUNT UNLOCK;