Locking and Unlocking Oracle User Accounts Jun 27th, 2011 9:54 pm To lock an Oracle user account open sqlplus and execute: 1 ALTER USER username ACCOUNT LOCK; To unlock an Oracle user account open sqlplus and execute: 1 ALTER USER username ACCOUNT UNLOCK;