Справочник Пользователя для Oracle Audio Technologies B10508-01

Скачать
Страница из 186
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:
1.
Start SQL*Plus and log in as SYSDBA by using the following commands:
$ sqlplus /nolog
SQL> connect / as sysdba
2.
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.