Oracle PL/SQL Tutorial/SQL PLUS Session Environment/System User

Материал из SQL эксперт
Версия от 10:04, 26 мая 2010; Admin (обсуждение | вклад) (1 версия)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к: навигация, поиск

SCOTT is a demonstration account.

is typically installed with the database.

SCOTT"s default password is TIGER.

29. 32. System User 29. 32. 1. <A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/SYS.htm">SYS</a> 29. 32. 2. <A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/SYSTEMisanadministratoraccount.htm">SYSTEM is an administrator account.</a> 29. 32. 3. SCOTT is a demonstration account. 29. 32. 4. <A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/Thesyntaxforconnectingtoaremotedatabaseserviceis.htm">The syntax for connecting to a remote database service is:</a>

SYS

  1. is the owner of the data dictionary
  2. should only be used for administrative purposes.
  3. This account is basically the "master" DBA account.
  4. SYS"s default password is CHANGE_ON_INSTALL.

29. 32. System User 29. 32. 1. SYS 29. 32. 2. <A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/SYSTEMisanadministratoraccount.htm">SYSTEM is an administrator account.</a> 29. 32. 3. <A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/SCOTTisademonstrationaccount.htm">SCOTT is a demonstration account.</a> 29. 32. 4. <A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/Thesyntaxforconnectingtoaremotedatabaseserviceis.htm">The syntax for connecting to a remote database service is:</a>

SYSTEM is an administrator account.

  1. The SYSTEM user is the default administrative account created by Oracle when you install the database.
  2. If you do not have your own administrative account, you should use the SYSTEM user to create a new user and grant that user the DBA role.
  3. This new user will then be your default administrative account.
  4. SYSTEM"s default password is MANAGER.

29. 32. System User 29. 32. 1. <A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/SYS.htm">SYS</a> 29. 32. 2. SYSTEM is an administrator account. 29. 32. 3. <A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/SCOTTisademonstrationaccount.htm">SCOTT is a demonstration account.</a> 29. 32. 4. <A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/Thesyntaxforconnectingtoaremotedatabaseserviceis.htm">The syntax for connecting to a remote database service is:</a>

The syntax for connecting to a remote database service is:

sqlplus <username>/<password>@<service_name>

For example, 
C:\>sqlplus scott/tiger@happy
Источник — «http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/SQL_PLUS_Session_Environment/System_User&oldid=2878»