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.
Open Oracle Database and log in to the system with the database administrator's username and password.
Type "SQLPLUS" and press "Enter." This will force the SQL Plus program to start.
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;".
- Oracle usernames and passwords may be any combination of capital or lowercase letters, since they are not case sensitive.
- man thinking about internet security image by patrimonio designs from Fotolia.com