Oracle: Reactivate a database user

By | February 8, 2017

I am always very annoyed when my Oracle user is automatically expired and locked. This is done automatically at 180 days in some installations.

The following are some very easy steps for a question that everybody is asking again and again on forums.

STEP 1: Connect to the DB


sqlplus / as sysdba

STEP 2: Update the password


ALTER USER myUser IDENTIFIED BY newPassword;

STEP 3: Unlock user


ALTER USER myUser ACCOUNT UNLOCK;

[paypal_donation_button]

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.