How to change Oracle database password

The method for oracle to change the database password is:

1. Use CRT to connect to the server where the oracle database is located as the user who installed the oracle database. (Take the server as linux as an example)

##2. Enter the command: sqlplus /nolog, enter the oracle console, and enter conn /as sysdba; enter as DBA role.

#3. After the connection is successful, enter "select username from dba_users" to view the user list.

4. If you modify a user's password, the format of the modified user password is:

alter user username identified by new password;

Take apps as an example, change the password to 123456. You can enter

alter user apps identified by 123456;

5. The modification is successful.

## Recommended tutorial: "

Oracle Tutorial

"

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!