How to change oracle user password

How to modify the oracle user password: First connect to the server where the oracle database is located and enter the oracle console; then enter "select username from dba_users" to view the user list; finally enter to modify the user password.

The operating environment of this tutorial: Windows 7 system, Oracle version, DELL G3 computer.

How to modify the oracle user password:

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 enterconn / 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 want to change the password of a certain user, change the user password format to:

alter user 用户名 identified by 新密码；

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

alter user apps identified by 123456;

#5. The modification is successful.

## Recommended (free):

oracle

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