http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FUser_Previliege%2FCreate_User
Oracle PL/SQL/User Previliege/Create User - История изменений
2026-07-15T18:55:27Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL/User_Previliege/Create_User&diff=1118&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:19Z
<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/User_Previliege/Create_User&diff=1119&oldid=prev
Admin: 1 версия
2010-05-26T09:55:06Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Create a user and drop it==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
create user sqle identified by password;<br />
grant create session, dba to sqle;<br />
connect sqle/password;<br />
--DROP USER sqle;<br />
<br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Create user and assign password==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> create user user1 identified by VALUES "1A2DD3CCEE354DFA";<br />
SQL><br />
SQL><br />
SQL> drop user user1;<br />
<br />
<br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Create user: default tablespace, temporary tablespace, quota==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> create user aNewUser<br />
2 identified by doomed<br />
3 default tablespace users<br />
4 temporary tablespace temp<br />
5 quota unlimited on users;<br />
User created.<br />
SQL><br />
SQL><br />
SQL> grant create session, create table to aNewUser;<br />
Grant succeeded.<br />
SQL><br />
SQL> connect aNewUser/doomed;<br />
Connected.<br />
SQL><br />
SQL> create table employees_backup (<br />
2 employee_id number,<br />
3 last_name varchar2(30),<br />
4 email varchar2(100)<br />
5 );<br />
Table created.<br />
SQL><br />
SQL> drop table employees_backup;<br />
Table dropped.<br />
SQL><br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Create User demo==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> CREATE USER Bob IDENTIFIED BY mypass;<br />
User created.<br />
<br />
<br />
</source></div>
Admin