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;
Unknown's avatar

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.

Leave a Reply

Discover more from SmartTechWays - Innovative Solutions for Smart Businesses

Subscribe now to keep reading and get access to the full archive.

Continue reading