Sunday, February 28, 2016

How to change oracle DB user's password

We can use the alter command to change the password of an oracle user. This is as follows.


SQL> Alter user <USER_NAME> identified by <PASSWORD>;

<USER_NAME> - Name of the oracle user
<PASSWORD> - New password that needs to set to oracle user


SQL> Alter user scott identified by tiger;

No comments:

Post a Comment

back to top