8/17/2017

ORACLE How to change oracle user's password

The Oracle database allows the users to change their passwords as follows:
SQL> ALTER USER me IDENTIFIED BY my_new_password;
or, alternatively, to use the PASSWORD command, which prompts for the old and new passwords.
SQL> password;
Of course, if the user has forgotten their old password, the DBA can do the necessary:
SQL> ALTER USER forgetful_user IDENTIFIED BY a_new_password;
Enjoy.

No comments:

Post a Comment

Popular Posts