创建用户
1
create user gzsly_quality identified by "gzsly_quality";
授权
1
2
3
grant create session to gzsly_quality;
grant create table to gzsly_quality;
grant create view to gzsly_quality;
创建表空间
1
2
3
4
create tablespace gzsly_quality
datafile '/oracel/tablespace/gzsly_quality.dbf'
size 200M
autoextend on next 5M maxsize 3000M;
授权用户表空间
1
alter user gzsly_quality quota unlimited on gzsly_quality;
修改用户缺省表空间
1
Alter user gzsly_quality default tablespace gzsly_quality;
查看用户表空间
1
select username,default_tablespace from dba_users;
查询所有用户
1
select * from all_users;
删除用户
1
drop user gzsly_quality CASCADE
删除表空间
1
drop tablespace gzsly_quality including contents and datafiles
<h2><a id="_0"></a>创建用户</h2>
<pre><div class="hljs"><code class="lang-sql"><span class="hljs-keyword">create</span> <span class="hljs-keyword">user</span> gzsly_quality <span class="hljs-keyword">identified</span> <span class="hljs-keyword">by</span> <span class="hljs-string">"gzsly_quality"</span>;
</code></div></pre>
<h2><a id="_6"></a>授权</h2>
<pre><div class="hljs"><code class="lang-sql"><span class="hljs-keyword">grant</span> <span class="hljs-keyword">create</span> <span class="hljs-keyword">session</span> <span class="hljs-keyword">to</span> gzsly_quality;
<span class="hljs-keyword">grant</span> <span class="hljs-keyword">create</span> <span class="hljs-keyword">table</span> <span class="hljs-keyword">to</span> gzsly_quality;
<span class="hljs-keyword">grant</span> <span class="hljs-keyword">create</span> <span class="hljs-keyword">view</span> <span class="hljs-keyword">to</span> gzsly_quality;
</code></div></pre>
<h2><a id="_14"></a>创建表空间</h2>
<pre><div class="hljs"><code class="lang-sql"><span class="hljs-keyword">create</span> <span class="hljs-keyword">tablespace</span> gzsly_quality
<span class="hljs-keyword">datafile</span> <span class="hljs-string">'/oracel/tablespace/gzsly_quality.dbf'</span>
<span class="hljs-keyword">size</span> <span class="hljs-number">200</span>M
<span class="hljs-keyword">autoextend</span> <span class="hljs-keyword">on</span> <span class="hljs-keyword">next</span> <span class="hljs-number">5</span>M <span class="hljs-keyword">maxsize</span> <span class="hljs-number">3000</span>M;
</code></div></pre>
<h2><a id="_23"></a>授权用户表空间</h2>
<pre><div class="hljs"><code class="lang-sql"><span class="hljs-keyword">alter</span> <span class="hljs-keyword">user</span> gzsly_quality <span class="hljs-keyword">quota</span> <span class="hljs-keyword">unlimited</span> <span class="hljs-keyword">on</span> gzsly_quality;
</code></div></pre>
<h2><a id="_29"></a>修改用户缺省表空间</h2>
<pre><div class="hljs"><code class="lang-sql"><span class="hljs-keyword">Alter</span> <span class="hljs-keyword">user</span> gzsly_quality <span class="hljs-keyword">default</span> <span class="hljs-keyword">tablespace</span> gzsly_quality;
</code></div></pre>
<h2><a id="_35"></a>查看用户表空间</h2>
<pre><div class="hljs"><code class="lang-sql"><span class="hljs-keyword">select</span> username,default_tablespace <span class="hljs-keyword">from</span> dba_users;
</code></div></pre>
<h2><a id="_41"></a>查询所有用户</h2>
<pre><div class="hljs"><code class="lang-sql"><span class="hljs-keyword">select</span> * <span class="hljs-keyword">from</span> all_users;
</code></div></pre>
<h2><a id="_47"></a>删除用户</h2>
<pre><div class="hljs"><code class="lang-sql"><span class="hljs-keyword">drop</span> <span class="hljs-keyword">user</span> gzsly_quality <span class="hljs-keyword">CASCADE</span>
</code></div></pre>
<h2><a id="_53"></a>删除表空间</h2>
<pre><div class="hljs"><code class="lang-sql"><span class="hljs-keyword">drop</span> <span class="hljs-keyword">tablespace</span> gzsly_quality <span class="hljs-keyword">including</span> <span class="hljs-keyword">contents</span> <span class="hljs-keyword">and</span> <span class="hljs-keyword">datafiles</span>
</code></div></pre>
