Saturday, 3 September 2011

Locking and Unlocking Oracle Accounts

To lock an Oracle user account open sqlplus and execute:
alter user <username> account lock;

To unlock an Oracle user account open sqlplus and execute:
alter user <username> account unlock;

No comments:

Post a Comment