Saturday, 23 July 2011

Oracle >> How to Lock/Unlock a Oracle user Account

Mostly there are 2 ways by we can Lock/Unlock the Oracle user Account.

1. By using GUI InterFace

Home>Administration>Manage Database Users
=> Then Provide the user Id & Password
=> Unlock/Lock

2. By using CUI InterFace(Command Line)

Below 2 statements will help you to lock or unlock Oracle database user accounts. SQL> ALTER USER username ACCOUNT LOCK; SQL> ALTER USER username ACCOUNT UNLOCK;