http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSQL_PLUS_Session_Environment%2FSystem_UserOracle PL/SQL Tutorial/SQL PLUS Session Environment/System User - История изменений2026-05-25T21:51:45ZИстория изменений этой страницы в викиMediaWiki 1.30.0http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/SQL_PLUS_Session_Environment/System_User&diff=2877&oldid=prev в 13:45, 26 мая 20102010-05-26T13:45:46Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/SQL_PLUS_Session_Environment/System_User&diff=2878&oldid=prevAdmin: 1 версия2010-05-26T10:04:16Z<p>1 версия</p>
<p><b>Новая страница</b></p><div>== SCOTT is a demonstration account.==<br />
<br />
<p>is typically installed with the database.</p><br />
<p>SCOTT"s default password is TIGER.</p><br />
29. 32. System User<br />
29. 32. 1. <br />
<A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/SYS.htm">SYS</a><br />
29. 32. 2. <br />
<A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/SYSTEMisanadministratoraccount.htm">SYSTEM is an administrator account.</a><br />
29. 32. 3. <br />
SCOTT is a demonstration account.<br />
29. 32. 4. <br />
<A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/Thesyntaxforconnectingtoaremotedatabaseserviceis.htm">The syntax for connecting to a remote database service is:</a><br />
<br />
== SYS==<br />
<br />
<OL><LI>is the owner of the data dictionary</LI><LI>should only be used for administrative purposes.</LI><LI>This account is basically the "master" DBA account.</LI><LI>SYS"s default password is CHANGE_ON_INSTALL.</LI></OL><br />
29. 32. System User<br />
29. 32. 1. <br />
SYS<br />
29. 32. 2. <br />
<A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/SYSTEMisanadministratoraccount.htm">SYSTEM is an administrator account.</a><br />
29. 32. 3. <br />
<A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/SCOTTisademonstrationaccount.htm">SCOTT is a demonstration account.</a><br />
29. 32. 4. <br />
<A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/Thesyntaxforconnectingtoaremotedatabaseserviceis.htm">The syntax for connecting to a remote database service is:</a><br />
<br />
== SYSTEM is an administrator account.==<br />
<br />
<OL><LI>The SYSTEM user is the default administrative account created by Oracle when you install the database.</LI><LI>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.</LI><LI>This new user will then be your default administrative account.</LI><LI>SYSTEM"s default password is MANAGER.</LI></OL><br />
29. 32. System User<br />
29. 32. 1. <br />
<A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/SYS.htm">SYS</a><br />
29. 32. 2. <br />
SYSTEM is an administrator account.<br />
29. 32. 3. <br />
<A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/SCOTTisademonstrationaccount.htm">SCOTT is a demonstration account.</a><br />
29. 32. 4. <br />
<A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/Thesyntaxforconnectingtoaremotedatabaseserviceis.htm">The syntax for connecting to a remote database service is:</a><br />
<br />
== The syntax for connecting to a remote database service is:==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
sqlplus <username>/<password>@<service_name><br />
<br />
For example, <br />
C:\>sqlplus scott/tiger@happy</source></div>Admin