Tuesday, October 13, 2009

Unlock an user account in oracle

In my development database there are many users and one of the user account got locked. I thought of contacting DBA to unlock the account. Usually we don't have the priviliges.

But to check my luck I've logged into Database as another user and executed the following command

ALTER USER USER_NAME ACCOUNT UNLOCK

As the priviliges were there the account got unlocked.

No comments:

Powered By Blogger