User passwords, To change a password, Configuration tasks to perform as the system user – Oracle Audio Technologies ORACLE9I B10508-01 User Manual

Page 88: Create additional openvms accounts

Advertising
background image

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.

Advertising