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.

Syntax:

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

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


Example:

SQL> Alter user scott identified by tiger;




No comments:

Post a Comment

back to top