Unlocking and resetting passwords manually, Reviewing user names and passwords – Oracle Audio Technologies ORACLE9I B10508-01 User Manual

Page 95

Starter Database Contents

Post-Installation

5-19

Unlocking and Resetting Passwords Manually

To manually change a password and unlock an account, review the list of default
administrative user names, passwords, and functions in

Select a user, and then unlock and reset the password by

using the following commands:

Start SQL*Plus and log in as SYSDBA by using the following commands:

$ sqlplus /nolog

SQL> connect / as sysdba

Change the password by using the following command:

SQL> ALTER USER

USERNAME

IDENTIFIED BY

PASSWORD

ACCOUNT

UNLOCK

The alter statement will both reset the password and unlock the account.

Reviewing User Names and Passwords

All databases that are created by Database Configuration Assistant include the SYS,
SYSTEM, and DBSNMP user names and passwords

In addition, Oracle

Corporation provides several other administrative users

Unlock users and reset

passwords before using these administrative accounts.

Note:

If you want unauthenticated access to your data via HTTP,

then unlock the ANONYMOUS user account.

See Also:

Oracle9i Database Administrator’s Guide for more

information on unlocking passwords after installation and for
information on Oracle security procedures and best security
practices.

Oracle Enterprise Manager Administrator’s Guide for more
information on using Oracle Security Manager or Oracle DBA
Studio to change passwords.

Note:

To unlock administrative user passwords after installation,

click the Password Management button in the Database
Configuration Assistant

window.