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


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: Logo

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