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.

_____________________________________________________________________________________________________________________

Website Stats