Change password of an user in Oracle

Change password of an user

Check the user status and existence

select username, account_status from dba_users where username = 'SCOTT';

Change the Password of an User

ALTER USER SCOTT identified by NEW_PWD;

You can also lock and unlock the user if its show locked in Account_status

-- Unlock/lock a user
ALTER USER SCOTT account unlock;
ALTER USER SCOTT account lock;

If user can change password on first login attempt

ALTER USER SCOTT password expire;

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

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