User Passwords
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
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.
