No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search


To have a better experience, please upgrade your IE browser.

Knowledge Base

How do I change the password of an Oracle database user

Publication Date:  2016-11-21  |   Views:  892  |   Downloads:  0  |   Document ID:  EKB1000379543


Issue Description

How do I change the password of an Oracle database user?


1. Log in to the SUSE Linux as user oracle.
2. On the command line interface (CLI), run the following command to connect to the Oracle database:
$ sqlplus / as sysdba

The user name and password are required in remote login mode. The following describes how to use the command to connect the system user to the Oracle database with password testpwd.
$ sqlplus system/testpwd as sysdba

If the information similar to the following is displayed, the system user is connected to the Oracle database:

3. Run the following command to change the password of the database user system:
> alter user system identified by testpwd;

The method of changing other Oracle user passwords is the same as the method of changing the password of the database user system. To be specific, system is the database user name to be changed, and testpwd is the password of the user-defined system user.

To ensure user password security, design passwords that meet the complexity requirement and modify the passwords periodically.

If the return value is User altered, the password is successfully changed. Otherwise, locate the cause as prompted.