获得数据库对象的方法探讨

韩冰

<><FONT color=#f70909>关键字 <a href="http://hackbase.com/hacker" target="_blank" >数据库</A> 对象
原作者姓名 Fang</FONT> </P>
6 O. F! S, {: ?, Z3 q5 W: @0 z( x<>SQL SERVER
" ]* L# C4 Q5 g2 W* x/ c1 ^% j取得<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>名的方法
  N1 ]3 ~( T) p; r/ n系统存储过程sp<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>helpdb</P>
<>或者</P>
) G3 W; m( q" w, {6 A$ Q<>USE master</P>
, W  v3 k5 ^& M7 P+ b# ]0 r6 [<>SELECT sysdb.name AS dbname, xlogin.name AS owner FROM sysdatabases AS sysdb LEFT JOIN sysxlogins AS xlogin ON sysdb.sid = xlogin.sid</P>
  f# y) f/ I( X4 T7 }<>
+ G2 {- M+ C) D$ _/ ssp<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>helpdb获得的内容更准确：第二种方式无法获取Windows NT登陆用户。</P>
$ L- A' x# c7 _9 C5 G1 Q  g/ A* C<>取得表的方法
系统存储过程</P>
<>USE xxx</P>
# r, x- J6 C* g" z' b4 ?<>EXEC sp<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>help</P>
1 @& w, R+ ^! z# m# p) ]2 ~<>或者</P>
0 J/ ]$ |( A+ F5 s) c. U# Y! R<>获取指定<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>的用户表：</P>
. p% ?4 m% o6 F. c' ]<>USE DBAudit
SELECT sysobjects.name AS tname, sysusers.name AS owner FROM sysobjects LEFT JOIN sysusers ON sysobjects.uid = sysusers.uid WHERE type = 'U'</P>
<>获取指定<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>的系统表：</P>
+ h/ @5 x. Q  r( [<>USE DBAudit
+ q6 ^1 s& n: k" f0 OSELECT sysobjects.name AS tname, sysusers.name AS owner FROM sysobjects LEFT JOIN sysusers ON sysobjects.uid = sysusers.uid WHERE type = 'S'</P>
<>或者统一使用：</P>
; M1 `6 ?% e5 ]& ~9 p1 l<>USE DBAudit</P>
9 N  A# m7 L! m. O  }<>SELECT sysobjects.name AS name, sysusers.name AS owner, type, sysobjects.id AS id FROM sysobjects LEFT JOIN sysusers ON sysobjects.uid = sysusers.uid WHERE type = 'U' OR type = 'S'</P>
<>注：</P>
<>sysobjects中type字段类型解释：</P>
<>C = CHECK 约束</P>
: |# ?# A/ o* }' D% \& z<>D = 默认值或 DEFAULT 约束</P>
<>F = FOREIGN KEY 约束</P>
<>L = 日志</P>
0 ]! V5 z; c5 v0 `* x, x# a<>FN = 标量函数</P>
$ l2 g* z% V! y! M  \/ x3 k& Q7 L<>IF = 内嵌表函数</P>
<> = 存储过程</P>
<>K = PRIMARY KEY 约束（类型是 K）</P>
( ]; O6 Q" x6 p1 o0 |<>RF = 复制筛选存储过程</P>
<P>S = 系统表</P>
<P>TF = 表函数</P>
( X3 f2 {) d# J- |. \<P>TR = 触发器</P>
: @* g8 R) P  g+ D+ g<P>U = 用户表</P>
/ S  J$ J! N& v, Y. c5 F0 L9 ]5 {& s<P>UQ = UNIQUE 约束（类型是 K）</P>
<P>V = 视图</P>
<P>X = 扩展存储过程</P>
7 i# C. I& {8 _* P/ }6 U<P>取得列的方法
系统存储过程</P>
<P>USE xxxDatabase</P>
<P>EXEC sp<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>help xxxTable</P>
- n0 J6 B$ m$ {<P>或者</P>
<P>USE xxxDatabase</P>
<P>SELECT syscolumns.name AS name, systypes.name AS type FROM syscolumns LEFT JOIN systypes ON syscolumns.xtype = systypes.xtype WHERE syscolumns.id = xxxTableId</P>
/ P4 y+ H, n3 X7 R) C<P>这两种方法都可以取得包括视图的列。</P>
<P>取得视图的方法
系统存储过程</P>
- I* G% X- t; u: ]* \<P>USE xxx</P>
/ V6 L1 ^  r- t1 ?4 c& g  F" V<P>EXEC sp<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>help</P>
+ |4 M& Y( t9 @3 r<P>或者</P>
$ B0 U/ p. h" v, a3 K. }/ \<P>获取指定<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>的视图：</P>
* [6 v+ _/ \2 d, \: g+ `<P>USE DBAudit</P>
<P>SELECT sysobjects.name AS name, sysusers.name AS owner FROM sysobjects LEFT JOIN sysusers ON sysobjects.uid = sysusers.uid WHERE type = 'V' </P>
: R( t, }$ y  W% [<P>获取指定<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>的视图的内容：</P>
% ]& A) d9 ~/ O- K: K/ [0 e7 Q<P>EXEC sp<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>helptext xxxObject</P>
<P>取得存储过程的方法
9 Z" N8 B. n! l9 ~5 b系统存储过程</P>
<P>USE xxx</P>
<P>EXEC sp<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>help</P>
, S- U3 R+ K" D& o' M* K<P>或者</P>
& L1 l8 y- ~( @, Y" o2 @<P>获取指定<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>的存储过程或者扩展存储过程：</P>
& n5 i) D8 I9 m<P>USE DBAudit</P>
+ [  k/ _) A' s) k6 A4 ?<P>SELECT sysobjects.name AS name, sysusers.name AS owner, type FROM sysobjects LEFT JOIN sysusers ON sysobjects.uid = sysusers.uid WHERE type = 'P' OR type = 'X'</P>
<P>获取指定<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>的存储过程或者扩展存储过程的内容：</P>
0 F: d1 l' K# `<P>EXEC sp<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>helptext xxxObject</P>
<P>无法获取加密的存储过程。扩展存储过程只能得到dll程序名。</P>
$ J7 `: C8 `. s5 n' B* E3 s6 l<P>取得函数的方法
系统存储过程</P>
; @- M$ t/ R8 ^' f<P>USE xxx</P>
<P>EXEC sp<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>help</P>
9 t% W2 g7 H5 S2 e& p( ?& U4 u<P>或者</P>
<P>获取指定<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>的各种函数（内嵌函数等）：</P>
<P>USE DBAudit</P>
<P>SELECT sysobjects.name AS name, sysusers.name AS owner, type FROM sysobjects LEFT JOIN sysusers ON sysobjects.uid = sysusers.uid WHERE type = 'FN' OR type = 'IF' OR type = ‘TF'</P>
<P>获取指定<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>的函数的内容：</P>
<P>EXEC sp<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>helptext xxxObject</P>
<P>只能获取用户定义的函数内容。</P>
* C# H- q  [2 P4 Q3 U<P>取得触发器的方法
系统存储过程</P>
7 _  E; H) x9 k) F<P>USE xxx</P>
<P>EXEC sp<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>helptrigger xxxTable</P>
( h! R0 D0 G8 i7 O% r<P>或者</P>
' n; G2 J) R9 L' N5 Z& t4 F2 g3 v<P>获取指定<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>的表的触发器：</P>
0 Z' t; g$ B2 V( S9 }( L5 ]<P>SELECT sysobj1.name AS name, sysusers.name AS owner FROM sysobjects AS sysobj1 LEFT JOIN sysobjects AS sysobj2 ON sysobj1.parent<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>obj = sysobj2.id LEFT JOIN sysusers ON sysobj1.uid = sysusers.uid WHERE sysobj1.type = 'TR'AND sysobj2.name = 'xxxTable'</P>
$ \9 e9 W( W5 O, W# _# F! I<P>取得索引的方法
; \0 p0 E5 Q4 y4 ^系统存储过程</P>
8 G! D# j- l1 y) c<P>USE xxx</P>
3 J5 \) H% n9 u# A0 _  K<P>EXEC sp<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>helpindex xxxTable </P>
<P>用户
/ c4 ]. i! {* K1 T1 a% M+ {系统存储过程</P>
. V) R2 f! T! _/ u$ H<P>USE xxx</P>
<P>EXEC sp<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>helpuser</P>
) [$ O) Q: o$ z2 J% @, f+ V" r% S<P>角色
系统存储过程</P>
* X% k6 |* W: ~<P>USE xxx
( }( P: p2 u+ R+ `- N" LEXEC sp<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>helprole</P>

+ b  x1 w! D) s3 }" ?: `<P>ORACLE
特殊
$ w# i" q6 \; m&Oslash;         ORACLE只能连接特定<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>，不能自动扫描<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>对象。</P>
/ W1 Y( |7 F; [  }8 f- A$ V<P>&Oslash;         ORACLE表必须用用户来区别，否则表可能重名。</P>
# L/ f5 f% R( }4 h" V6 ~4 m<P>&Oslash;         ORACLE不能区别系统表或者是用户表，因此只能由管理员选择扫描某些特定用户的表。</P>
<P>取得<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>名的方法
- b8 F' C0 i  K: c, R( X) p只能由用户指定<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>，不能自动扫描到特定<a href="http://hackbase.com/hacker" target="_blank" >数据库</A><a href="http://vip.hackbase.com/" target="_blank" >服务</A>器上的所有<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>。</P>
<P>取得表的方法
存储<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>表的系统表/视图主要有：</P>
<P>DBA<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TABLES</P>
. p: m8 i/ X+ G& e; u( n; Q  f3 `. E<P>描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的对象以及相关的表。</P>
<P>ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TABLES</P>
: e) `2 ~. h3 s6 ]1 H* u<P>描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的用户可以访问的对象以及相关的表。</P>
" u$ \; F, [( g3 a! a9 K<P>USER<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TABLES</P>
<P>描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中当前用户拥有的对象以及相关的表。</P>
<P>
0 q* w$ H2 o9 rDBA<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A> TABLES</P>
2 R2 V  `3 x  w4 r! A<P>描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有相关的表。</P>
<P>ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A> TABLES</P>
<P>描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的用户可以访问的相关的表。</P>
; ~6 s8 K* L( Y& h0 c<P>USER<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A> TABLES</P>
<P>描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中当前用户拥有的相关的表。</P>
* K0 M3 f+ g5 \) e/ q9 B# A<P>
因此，可以从ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TABLES中取得隶属于指定用户的表：</P>
$ L. Q. X8 f. W2 v3 S/ M<P>SELECT TABLE<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME FROM SYS.ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TABLES WHERE OWNER = 'DBAUDIT';</P>
<P>取得隶属于指定表空间的表：</P>
* @" |; J' ^+ T$ w& e9 Q9 G$ p<P>SELECT TABLE<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME FROM SYS.ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TABLES WHERE TABLESPACE<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME = 'DBAUDIT';</P>
0 K6 D4 [) ]& h2 L; m1 e<P>
也可以不指定用户名，从而取得所有的表。</P>
<P>SELECT TABLE<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME FROM SYS.ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TABLES；</P>
9 p$ @! {7 W# x& R<P>取得列的方法
; {/ B5 u8 m3 _1 K0 }存储<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>表的列属性的系统表/视图主要有：</P>
<P>DBA<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TAB<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>COLUMNS
. S( d# U  F. @描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的表的列属性。
ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TAB<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>COLUMNS
描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的用户可以访问的表的列属性。
USER<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TAB<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>COLUMNS
描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中当前用户拥有的表的列属性。
ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TAB<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>COLS</P>
4 m3 ]! Y6 `# W( U( G<P>描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的用户可以访问的表的列属性。</P>
<P>
因此，可以从ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TAB<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>COLUMNS中取得隶属于指定用户的表：
SELECT COLUMN<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME FROM SYS.ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TAB<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>COLUMNS WHERE TABLE<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME = 'TASK' AND OWNER = 'DBAUDIT';</P>
  H. I6 B, e; F/ ?0 h" S4 u<P>取得视图的方法
! Y. \# D9 U5 o存储<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>视图的系统表/视图主要有：</P>
<P>DBA<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>VIEWS
& Y3 _4 j! u2 q' l4 Y1 T描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的视图的属性。
2 a& ]1 y: f( x0 zALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>VIEWS
2 O0 L, u& T6 |- S* K1 C描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的用户可以访问的视图的属性。
. f% X& }9 H! f% V# [USER<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>VIEWS</P>
<P>描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的当前用户拥有视图的属性。</P>
- W( z! l. u  K+ l) c  _: M<P>
$ H; B2 A* `$ S' c- j3 x因此，可以从ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>VIEWS中取得隶属于指定用户的视图：
, @2 {- m( Q4 d# }* w( SSELECT VIEW<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME FROM SYS.ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>VIEWS WHERE OWNER = 'DBAUDIT';</P>
" ?" r& E7 V. h2 H: n/ T% I+ h<P>取得存储过程的方法
存储系统对象的系统表/视图有：</P>
1 f# {' A& C0 r9 s  r" X<P>DBA<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>OBJECTS</P>
<P>描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的对象。</P>
7 a7 b$ ^. n3 d$ P1 W5 }& s<P>ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>OBJECTS
描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的可以访问的对象。
+ C7 l  X7 m; ?& nUSER<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>OBJECTS</P>
<P>描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的当前用户拥有的对象。</P>
<P>SYS<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>OBJECTS</P>
$ s2 k  |2 @7 h; a<P>描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的系统对象。？</P>
<P>
对象类型有：</P>
<P>CONSUMER GROUP</P>
<P>CONTEXT</P>
<P>DIRECTORY</P>
& S- j' K% X1 d0 c, ^<P>FUNCTION</P>
<P>INDEX</P>
<P>INDEX PARTITION</P>
<P>INDEXTYPE</P>
<P>JAVA CLASS</P>
5 c% U% X6 o% [2 f<P>JAVA DATA</P>
<P>JAVA RESOURCE</P>
: m, W1 t' [* c6 i. Q1 _<P>JAVA SOURCE</P>
<P>LIBRARY</P>
0 `9 x/ s) p+ i# x1 @3 ^<P>LOB</P>
<P>MATERIALIZED VIEW</P>
: `5 v, v" M0 V  b<P>OPERATOR</P>
<P>PACKAGE</P>
3 w8 W, ^6 m6 l9 l4 J3 W% H<P>PACKAGE BODY</P>
3 d1 c' o& ~9 O# B" {: A8 D<P>PROCEDURE</P>
& D( \  h" M1 l% U! |5 ~4 j) T# w<P>QUEUE</P>
<P>SEQUENCE</P>
$ X0 c- Y: ?, X. K" e<P>SYNONYM</P>
<P>TABLE</P>
<P>TABLE PARTITION</P>
2 _  U5 i+ a# {" G0 F( M0 Y<P>TRIGGER</P>
4 f# @2 _# Y# O<P>TYPE</P>
( `  N1 n' h; u* w4 x8 Q1 H<P>TYPE BODY</P>
0 o. S' P6 G. ^2 N<P>VIEW</P>
<P>
/ S( V. N$ @# u6 Y4 U( e: E因此，取得存储过程可以用：</P>
6 V# A- w2 Q/ o5 D# g9 u$ ^<P>SELECT OBJECT<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME FROM SYS.ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>OBJECTS WHERE OBJECT<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TYPE = 'PROCEDURE';</P>
, j- Z/ d. _: p8 N8 |- ~% s  H<P>取得隶属于某个用户的存储过程可以用：</P>
( M4 m: G! b1 u<P>SELECT OBJECT<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME FROM SYS.ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>OBJECTS WHERE OBJECT<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TYPE = 'PROCEDURE' AND OWNER = ‘DBAUDIT';</P>
1 s8 C% X, l6 }% x1 q<P>
0 h5 Q# |1 c" f; H* `; _同样，取得其他的对象也可以用这个方法，包括表，视图等。</P>
1 Q* Q  ^; e5 m8 T- `: i$ d<P>取得存储过程内容的方法
% \; {) E& O; R1 l" m2 o4 P$ P对象类型为类型、类型体、过程、函数、包、包体，JAVA源<a href="http://hackbase.com/hacker" target="_blank" >代码</A>的所有对象的源<a href="http://hackbase.com/hacker" target="_blank" >代码</A>都存储在几个系统表/视图中：</P>
9 t. _% o7 \9 W7 D* j- `9 n<P>DBA<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>SOURCE</P>
0 I* T) Z: H5 r' i# O<P>存储所有<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>对象的源<a href="http://hackbase.com/hacker" target="_blank" >代码</A>。</P>
<P>ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>SOURCE
存储所有可以访问的<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>对象的源<a href="http://hackbase.com/hacker" target="_blank" >代码</A>。
. c9 O* p- c6 T3 ]2 f. t1 ^& }" xUSER<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>SOURCE</P>
( ~" z' k4 z1 y<P>存储所有当前用户拥有的<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>对象的源<a href="http://hackbase.com/hacker" target="_blank" >代码</A>。</P>
<P>
  R3 a) H* M. J; [+ |+ h4 v因此，取得存储过程源<a href="http://hackbase.com/hacker" target="_blank" >代码</A>的方法：</P>
<P>SELECT TEXT FROM SYS.ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>SOURCE WHERE NAME = ‘XXX' AND TYPE = ‘PROCEDURE';</P>
<P>取得函数的方法
3 t, o' P; V+ F同上，取得函数可以用：</P>
/ _! m: J  S  ~2 m5 ^. ?<P>SELECT OBJECT<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME FROM SYS.ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>OBJECTS WHERE OBJECT<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TYPE = 'FUNCTION';</P>
* G! z/ D& v3 E! p) z( q<P>取得隶属于某个用户的函数可以用：</P>
) j% B5 ^: u1 e# J( F<P>SELECT OBJECT<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME FROM SYS.ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>OBJECTS WHERE OBJECT<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TYPE = 'FUNCTION' AND OWNER = 'DBAUDIT';</P>
<P>
取得函数内容可以用：</P>
<P>SELECT TEXT FROM SYS.ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>SOURCE WHERE NAME = 'XXX' AND TYPE = 'FUNCTION';</P>
, d6 j( `$ L, h1 \% Q) q<P>取得触发器的方法
" u# a9 ~, Y6 n2 E, F% H6 s存储<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>触发器的系统表/视图主要有：</P>
. m, z5 t/ ^6 q6 x<P>DBA<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TRIGGERS
" I; h- `( w: n; D9 |3 O( w( \描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的触发器的属性。
2 E  o  v. w% x6 \6 |ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A> TRIGGERS
# a/ U; e" Z8 i- T4 ?9 g( @描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的用户可以访问的触发器的属性。
USER<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A> TRIGGERS</P>
& F- j3 Q( Z( t# a1 n* V  }<P>描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的当前用户拥有触发器的属性。</P>
  y: C2 d/ g0 w0 D9 P( `5 A<P>
$ J1 y2 v: `* S' w% ^因此，可以从ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A> TRIGGERS中取得隶属于指定用户的触发器：
SELECT TRIGGER<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME FROM SYS.ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TRIGGERS WHERE OWNER = 'DBAUDIT';</P>
! }/ Q: r  ^# G) |+ ~<P>
7 _$ o6 C2 o2 \) Y) q9 I, @( r取得触发器内容的方法：</P>
<P>SELECT TRIGGER<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>BODY FROM SYS.ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>TRIGGERS WHERE TRIGGER<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME = 'XXX';</P>
<P>取得索引的方法
7 w$ N5 o( q: L3 b# A存储<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>索引的系统表/视图主要有：</P>
; n6 Y) \+ q) g1 B4 T5 ]<P>DBA<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>INDEXES
/ C. i# ]6 t! d7 n描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的索引的属性。
. i* r. W8 {/ [8 ?: HALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A> INDEXES
描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的用户可以访问的索引的属性。
) T* {/ @) ]8 N6 P; h: S' GUSER<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A> INDEXES</P>
5 y( w9 v# i* l) |  F5 S<P>描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的当前用户拥有索引的属性。</P>
<P>
* u4 L1 h( G' }' p因此，可以从ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A> INDEXES中取得隶属于指定用户的索引：
+ ^. _6 j& h/ {% u: h# ~SELECT INDEX<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME,TABLE<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME FROM SYS.ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>INDEXES WHERE OWNER = 'DBAUDIT';</P>
<P>
取得索引相关的列的方法：</P>
; ]  N: O4 q' @8 i/ Y# r8 D8 U<P>SELECT COLUMN<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME FROM SYS.ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>IND<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>COLUMNS WHERE INDEX<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>NAME = 'XXX' AND TABLE<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>OWNER = 'DBAUDIT';</P>
- Y1 R% ~7 h8 ^! D6 k<P>用户
# T+ H7 I$ v- ]存储<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>用户的系统表/视图主要有：</P>
. b& H6 ?0 P1 d8 e4 ^: M0 i3 c<P>DBA<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>USERS
, e9 O' X# O* Z: q: S( B描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的用户的属性。
ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>USERS
; h* R3 O" [. e; d4 U) l描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中所有的用户的属性。
8 Y/ {) F& s3 DUSER<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>USERS</P>
<P>描述<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>中当前用户的属性。</P>
<P>
) [0 P2 g7 x3 i" \8 d! T因此，可以从ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>USERS中取得用户：
; n; ?3 l& o, jSELECT USER<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>ID, USERNAME FROM SYS.ALL<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>USERS;</P>