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

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World

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.

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer