http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FUser_Privilege%2FPassword
Oracle PL/SQL Tutorial/User Privilege/Password - История изменений
2026-04-04T21:45:58Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/User_Privilege/Password&diff=3224&oldid=prev
в 13:45, 26 мая 2010
2010-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/User_Privilege/Password&diff=3225&oldid=prev
Admin: 1 версия
2010-05-26T10:05:44Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Change the password for the current user using the PASSWORD command==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL><br />
SQL> PASSWORD<br />
Changing password for SYS<br />
Old password:<br />
New password:<br />
Retype new password:<br />
Password unchanged<br />
SQL></source><br />
<br />
<br />
<br />
== Changing a User"s Password Using the ALTER USER statement==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL> --CONNECT system/manager<br />
SQL> CREATE USER user1 IDENTIFIED BY pass1;<br />
User created.<br />
SQL><br />
SQL> GRANT CREATE SESSION TO user1;<br />
Grant succeeded.<br />
SQL><br />
SQL> ALTER USER user1 IDENTIFIED BY pass2;<br />
User altered.<br />
SQL><br />
SQL> DROP USER user1;<br />
User dropped.</source></div>
Admin