How to Change the Password for an Oracle User

by Susan Reynolds
Keep your database secure by changing passwords.

Keep your database secure by changing passwords.

man thinking about internet security image by patrimonio designs from Fotolia.com

Oracle is a type of database management system where data is stored in tables. Oracle can have several users in one network, and each user has a unique username and password. If you want to change the password for an Oracle user in your network, the database administrator can do so with Oracle's built-in settings. This keeps information secure, since only one user can change the settings.

Step 1

Open Oracle Database and log in to the system with the database administrator's username and password.

Step 2

Type "SQLPLUS" and press "Enter." This will force the SQL Plus program to start.

Step 3

Type "alter user (user_name) identified by (new_password);" substituting the user's information in each section. For example, to change the password for John Smith to "morning," you would type "alter user John_Smith identified by morning;".

Tip

  • Oracle usernames and passwords may be any combination of capital or lowercase letters, since they are not case sensitive.

About the Author

Susan Reynolds has been a writer since 2008. She holds a B.A. in English from the University of South Florida and is a licensed real estate agent in Florida.

Photo Credits

  • man thinking about internet security image by patrimonio designs from Fotolia.com