Oracle 10g 11g Syntax for Lock and Unlock a User Schema Account


Syntax:
To lock an Oracle user account: alter user username account lock;
To Unlock an Oracle User Account: alter user username account unlock;
Examples:
alter user scott account lock;
user scott altered.
alter scott cep account unlock;
user scott altered.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google