Lock and unlock an Oracle User with Alter command

Alter command for lock and unlock User

Lock the User

ALTER USER username ACCOUNT LOCK;
Example:
ALTER USER scott ACCOUNT LOCK;

Unlock the User

ALTER USER username ACCOUNT UNLOCK;
Example:
ALTER USER SCOTT ACCOUNT UNLOCK;

Related

Author: SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator. View all posts by SandeepSingh

Leave a ReplyCancel reply