How to change oracle database password

There are two ways to modify the Oracle database password: Use the SQL command: ALTER USER IDENTIFIED BY ; Use the Oracle Enterprise Manager console: Expand the Security tab> User > Right-click the user > Reset password.

Oracle Database Password Changing Guide

How to change the Oracle database password?

There are two main ways to change the Oracle database password:

1. Using SQL commands
2. Using Oracle Enterprise Manager Console

Use SQL command to change password

<code class="sql">ALTER USER username IDENTIFIED BY new_password;</code>

Among them,

• username is the user whose password you want to change
• new_password is the new password

For example:

<code class="sql">ALTER USER scott IDENTIFIED BY tiger;</code>

This will change the password of user scott to tiger.

Use Oracle Enterprise Manager Console to change the password

1. Log in to Oracle Enterprise Manager Console.
2. Expand the "Security" tab.
3. Select "User".
4. Right-click the user whose password you want to change and select "Reset Password".
5. Enter the new password and confirm.

Note

• The password will not take effect until the database is restarted.
• Ensure that the new password complies with Oracle's password policy requirements.
• It is recommended to change the password regularly to ensure database security.

• If you forget your password, you can:

  • Log in as the SYSDBA user and change your password.
  • Reset password file.

The above is the detailed content of How to change oracle database password. For more information, please follow other related articles on the PHP Chinese website!