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)

sqlplus /nolog, enter the oracle console, and enterconn / as sysdba;Enter as DBA role.

alter user 用户名 identified by 新密码；

alter user apps identified by 123456;

## 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!