db2cert7011-4-9.html

第一次上传 这是考试得时候收集得 有关DB2701认证得教程

</TR>
</TABLE>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td><font face="Verdana, sans-serif" size="-1"><a href="/developerWorks/cn/index.shtml">developerWorks 中国网站</a> : 
							<a href="/developerWorks/cn/dmdd/index.shtml">DB2 开发者园地</a> ： 
							<a href="/developerWorks/cn/cndmdd.nsf/dmdd-onlinecourse-bynewest?openview&count=20">教学 - 在线教程</a></font>
<br>
<img alt="服务器管理" src="imagemaster/masthead.jpg"></td><td width="*" valign="bottom" align="right"><a border="0" href="db2cert7011.zip"><img alt="下载 ZIP 文件" border="0" src="../i/icon-zip.gif"></a><a target="_blank" href="../tutorial_eng/index.html" border="0"><img alt="英文原文" border="0" src="../i/icon-source.gif"></a>
					&nbsp;&nbsp;&nbsp;
				</td>
</tr>
<tr>
<td height="2" colspan="2"><img height="2" width="1" src="../i/c.gif"></td>
</tr>
</table>
<TABLE border="0" cellpadding="0" cellspacing="0" width="100%">
<TR>
<TD width="150" height="1" bgcolor="#000000" colspan="6"><IMG alt="" height="1" width="150" src="../i/c.gif"></TD>
</TR>
<TR>
<TD background="../i/sw-gold.gif"><a border="0" href="index.html" onMouseOver="iOver('topmain'); iOver('bottommain'); self.status=mainblurb; return true;" onMouseOut="iOut('topmain'); iOut('bottommain'); self.status=''; return true;"><img alt="主菜单" border="0" src="../i/main.gif" name="topmain"></a></TD><TD background="../i/sw-gold.gif"><a border="0" onMouseOver="iOver('topsection'); iOver('bottomsection'); self.status=sectionblurb; return true;" onMouseOut="iOut('topsection'); iOut('bottomsection'); self.status=''; return true;" href="index4.html"><img alt="章节菜单" border="0" src="../i/section.gif" name="topsection"></a></TD><TD background="../i/sw-gold.gif"><a border="0" onMouseOver="iOver('topfeedback'); iOver('bottomfeedback'); self.status=feedbackblurb; return true;" onMouseOut="iOut('topfeedback'); iOut('bottomfeedback'); self.status=''; return true;" href="db2cert7011-7-3.html"><img alt="给出此教程的反馈意见" border="0" src="../i/feedback.gif" name="topfeedback"></a></TD><TD width="100%" background="../i/sw-gold.gif"><img src="../i/c.gif"></TD><TD background="../i/sw-gold.gif"><a border="0" onMouseOver="iOver('topprevious'); iOver('bottomprevious'); self.status=previousblurb; return true;" onMouseOut="iOut('topprevious'); iOut('bottomprevious'); self.status=''; return true;" href="db2cert7011-4-8.html"><img alt="上页" border="0" src="../i/previous.gif" name="topprevious"></a></TD><TD background="../i/sw-gold.gif"><a border="0" onMouseOver="iOver('topnext'); iOver('bottomnext'); self.status=nextblurb; return true;" onMouseOut="iOut('topnext'); iOut('bottomnext'); self.status=''; return true;" href="db2cert7011-4-10.html"><img alt="下页" border="0" src="../i/next.gif" name="topnext"></a></TD>
</TR>
</TABLE>
<table bgcolor="ffffff" cellspacing="0" cellpadding="2" border="0" height="400" width="100%">
<tr valign="bottom">
<a name="navskip"></a><td height="25" colspan="4"><img alt="4.DB2 安全性" src="imagemaster/titlebar4.jpg" border="0" height="25" width="562"></td>
</tr>
<tr>
<td bgcolor="ffffff" width="15">&nbsp;</td><td bgcolor="ffffff" width="12">&nbsp;</td><td valign="top" align="left" bgcolor="ffffff" width="*">
<p>
<br>
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td width="90%"><font size="4" face="Verdana, Arial, Helvetica"><b>设置特权</b></font></td><td width="200" align="right"><font size="1" face="Verdana, Arial, Helvetica"><nobr>   第 9 页（共11 页）</nobr></font></td>
</tr>
</table>
<br>
<br>
</p>
<font size="2" face="Verdana, Arial, Helvetica">
<p>特权给予用户以特定方式访问数据库对象的权限。以下列表汇总了不同数据库对象的特权。</p>
<p>
						
<b>数据库特权：</b>
					
</p>
<ul>
<li>
CONNECT 允许用户连接数据库。</li>
<li>
BINDADD 允许用户在数据库中创建新的包。</li>
<li>
CREATETAB 允许用户在数据库中创建新表。</li>
<li>
CREATE_NOT_FENCED 允许用户创建不受防护的用户定义的函数或存储过程。</li>
<li>
IMPLICIT_SCHEMA 允许用户用还不存在的模式创建对象。</li>
<li>
QUIESCE_CONNECT 允许用户在数据库抑制时访问它。</li>
<li>
CREATE_EXTERNAL_ROUTINE 允许用户创建用 C、Java<sup>TM</sup> 语言、OLE 和 COBOL 编写的存储过程。</li>
</ul>
<p>
						
<b>模式特权：</b>
					
</p>
<ul>
<li>
CREATEIN 允许用户创建模式内的对象。</li>
<li>
ALTERIN 允许用户更改模式内的对象。</li>
<li>
DROPIN 允许用户删除模式内的对象。</li>
</ul>
<p>要显式地创建新模式，可使用 <code>create schema</code> 命令：</p>
<pre>
<code style="font-family: Courier New, Courier, monospace; font-size: 12">
connect to sample user dbowner;
create schema dev authorization devuser;
</code>
</pre>
<p>
						
<b>表空间特权：</b>
					
</p>
<ul>
<li>
USE OF TABLESPACE 允许用户在指定的表空间内创建表。这一特权不能用于 SYSCATSPACE 或任何系统临时表空间。</li>
</ul>
<p>
						
<b>表和视图特权：</b>
					
</p>
<ul>
<li>
CONTROL 给予用户对表或视图的所有特权，以及将这些特权（CONTROL 除外）授予其他用户的能力。</li>
<li>
ALTER 允许用户更改表或视图。</li>
<li>
DELETE 允许用户删除表或视图的记录。</li>
<li>
INDEX 允许用户对表创建索引。</li>
<li>
INSERT 允许用户将记录项插入表或视图中。</li>
<li>
REFERENCES 允许用户创建和删除外键，指定关系中作为父代的表。</li>
<li>
SELECT 允许用户从表或视图中检索行。</li>
<li>
UPDATE 允许用户更新表或视图中的记录。这一特权还能限制用户只能更新指定的列：<code>grant update (workdept, job) on table employee to devuser;</code>
			
</li>
<li>
ALL PRIVILEGES 授予对于表或视图的上述全部特权（CONTROL 除外）。</li>
</ul>
<p>
						
<b>包特权：</b>
					
</p>
<ul>
<li>
CONTROL 提供用户重新绑定、删除或执行包的能力，以及将这些特权（CONTROL 除外）授予其他用户的能力。</li>
<li>
BIND 允许用户重新绑定现有的包。</li>
<li>
EXECUTE 允许用户执行包。</li>
</ul>
<p>
						
<b>索引特权：</b>
					
</p>
<ul>
<li>
CONTROL 允许用户删除索引。</li>
</ul>
<p>
						
<b>例程特权：</b>
					
</p>
<ul>
<li>
EXECUTE 允许用户执行用户定义的函数。</li>
</ul>
<p>
						
<b>序列特权</b>
					
</p>
<ul>
<li>
USAGE 允许用户将 NEXTVAL 和 PREVVAL 表达式用于序列对象。</li>
</ul>
<br>
</font></td>
</tr>
</table>
<TABLE border="0" cellpadding="0" cellspacing="0" width="100%">
<TR>
<TD background="../i/sw-gold.gif"><a border="0" href="index.html" onMouseOver="iOver('topmain'); iOver('bottommain'); self.status=mainblurb; return true;" onMouseOut="iOut('topmain'); iOut('bottommain'); self.status=''; return true;"><img alt="主菜单" border="0" src="../i/main.gif" name="bottommain"></a></TD><TD background="../i/sw-gold.gif"><a border="0" onMouseOver="iOver('topsection'); iOver('bottomsection'); self.status=sectionblurb; return true;" onMouseOut="iOut('topsection'); iOut('bottomsection'); self.status=''; return true;" href="index4.html"><img alt="章节菜单" border="0" src="../i/section.gif" name="bottomsection"></a></TD><TD background="../i/sw-gold.gif"><a border="0" onMouseOver="iOver('topfeedback'); iOver('bottomfeedback'); self.status=feedbackblurb; return true;" onMouseOut="iOut('topfeedback'); iOut('bottomfeedback'); self.status=''; return true;" href="db2cert7011-7-3.html"><img alt="给出此教程的反馈意见" border="0" src="../i/feedback.gif" name="bottomfeedback"></a></TD><TD width="100%" background="../i/sw-gold.gif"><img src="../i/c.gif"></TD><TD background="../i/sw-gold.gif"><a border="0" onMouseOver="iOver('topprevious'); iOver('bottomprevious'); self.status=previousblurb; return true;" onMouseOut="iOut('topprevious'); iOut('bottomprevious'); self.status=''; return true;" href="db2cert7011-4-8.html"><img alt="上页" border="0" src="../i/previous.gif" name="bottomprevious"></a></TD><TD background="../i/sw-gold.gif"><a border="0" onMouseOver="iOver('topnext'); iOver('bottomnext'); self.status=nextblurb; return true;" onMouseOut="iOut('topnext'); iOut('bottomnext'); self.status=''; return true;" href="db2cert7011-4-10.html"><img alt="下页" border="0" src="../i/next.gif" name="bottomnext"></a></TD>
</TR>
<TR>
<TD width="150" height="1" bgcolor="#000000" colspan="6"><IMG alt="" height="1" width="150" src="../i/c.gif"></TD>
</TR>
</TABLE>
<TABLE width="100%" cellpadding="0" cellspacing="0" border="0">
<TR>
<TD width="100%">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td><img alt="" height="1" width="1" src="../i/c.gif"></td>
</tr>
<tr valign="top">
<td class="bbg" height="21">　<a class="mainlink" href="/developerWorks/cgi-bin/click.cgi?url=http://www-900.ibm.com/cn/ibm/index.shtml">关于 IBM</a><span class="divider">　| </span><a class="mainlink" href="/developerWorks/cgi-bin/click.cgi?url=http://www-900.ibm.com/cn/ibm/privacy/index.shtml">隐私条约</a><span class="divider">　| </span><a class="mainlink" href="/developerWorks/cgi-bin/click.cgi?url=http://www-900.ibm.com/cn/ibm/legal/index.shtml">法律条款</a><span class="divider">　| </span><a class="mainlink" href="/developerWorks/cgi-bin/click.cgi?url=http://www-900.ibm.com/cn/ibm/contact/index.shtml">联系 IBM</a></td>
</tr>
</table>
</TD>
</TR>
</TABLE>
<script src="//www.ibm.com/common/stats/stats.js" language="JavaScript1.2" type="text/javascript"></script>
<noscript>
<img border="0" alt="" height="1" width="1" src="//stats.www.ibm.com/rc/images/uc.GIF?R=noscript"></noscript>
</body>
</html>