How to change Oracle database password? Update the password using the ALTER USER command through SQL*Plus. Modify the password in the Security tab through Oracle Enterprise Manager (OEM). When you have SYSDBA authority, change the password with the ALTER SYSTEM command.
How to change the Oracle database password
To change the Oracle database password, you can use the following steps:
1. Use the SQL*Plus tool
<code>sqlplus 用户名/旧密码@数据库名</code>
<code>sqlplus scott/tiger@orcl</code>
<code>ALTER USER 用户名 IDENTIFIED BY 新密码;</code>
<code>ALTER USER scott IDENTIFIED BY newpassword;</code>
2. Use Oracle Enterprise Manager (OEM)
3. Use the ALTER SYSTEM command
If you have SYSDBA permissions, you can use the ALTER SYSTEM command:
<code>ALTER SYSTEM SET PASSWORD = 新密码;</code>
<code>ALTER SYSTEM SET PASSWORD = newpassword;</code>
After changing the password, use the new password to reconnect to the database:
<code>sqlplus 用户名/新密码@数据库名</code>
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!