Computer Accessories User Manual

User Passwords
5-12 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS
User Passwords
Oracle Corporation recommends that you change the password for user names
immediately after installation.
To change a password:
1. Start SQL*Plus by using the following command:
$ sqlplus
2. Connect with the user name and password that you want to change by using
the following command:
Enter user-name: username/password
3. Change the password by using the following command:
SQL> ALTER USER USERNAME IDENTIFIED BY PASSWORD;
Configuration Tasks to Perform as the System User
Log in as the system user and perform the following tasks:
❏ Create Additional OpenVMS Accounts
❏ Automate Database Startup and Shutdown (Optional)
❏ Set Initialization Parameters
Create Additional OpenVMS Accounts
If necessary, create additional OpenVMS accounts with the AUTHORIZE utility.
Each DBA user on the system must be granted the ORA_DBA or ORA_<sid>_DBA
Rights Identifier.
Query the data dictionary view using SQL*Plus to list the accounts in the default
database
. Accounts in the database are based upon the products chosen in the
Oracle Universal Installer.
SQL> SELECT username from dba_users;
You should delete accounts that you do not need.