Oracle 11g user password expired locked

To find the details of the users in your DB, execute the following statement:

select username, account_status, expiry_date, lock_date from dba_users;

To unlock the account, execute the following:

alter user se account unlock;

To change the password, execute following:

alter user se identified by sepm;

NOTE:  Old and new password can be same.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s