Oracle Rootkit

HỌC VIỆN KỸ THUẬT MẬT MÃ KHOA AN AN TOÀN THÔNG TIN

BÁO CÁO BÀI TẬP LỚN

TẤN CÔNG ROOTKIT TRONG ORACLE 10G. Giảng viên hướng dẫn: Nguyễn Thị Hồng Hà Nhóm sinh viên thực thực hiện: -

ê Tu!n "nh Nguyễn #$ #$n "nh Nguyễn #i%t T& '(àn )*ng H(àng +u +u,n Ng Nghiêm

HÀ NỘI, 11/201

1

2

M!C L!C MỤC LỤC....................... LỤC.................................... .......................... ......................... ......................... .......................... ...................................3 ......................3 CÁC THUẬT NGỮ VÀ VIẾT TẮT............................ TẮT........................................ .........................................6 .............................6 DANH MỤC CÁC BẢNG..................... BẢNG.................................. .......................... .......................... ......................... ........................7 ............7 DANH MỤC CÁC HNH V!.................... V!................................. .......................... ......................... ................................." ....................." L#I N$I %&U...................... %&U................................... .......................... ......................... ......................... .......................... .......................... .................' ....' CH()NG *. T+NG ,UAN V- OOTKIT......................................................** OOTKIT......................................................** *.*. G/0/ 12/4 12/4 524 89 :; <=5 2>/........ 2>/............ ........ ........ ......... ......... ........ ......... ............ ............... ............... .........** ..** *.?. G/0/ 12/4 524 89 @@1/1.. @@1/1...... ........ ........ ........ ........ ......... ......... ........ ........ ......... ......... ........ ........ .......... ............* ......*** *.?.*. L52  @@1/1................... @@1/1................................ .......................... .......................... ......................... ..........................** ..............** *.?.?. %2 2EF....................... 2EF.................................... .......................... ......................... ......................... ..............................*? .................*? *.3. C52 125 2@>1 <= 5F @@1/1..................... @@1/1.................................. .........................................*? ............................*? *.3.*. C2/J: 49 / @@1/1.. @@1/1...... ........ ........ ........ ......... ......... ........ ........ ......... ......... ........ ........ ............ ............... .............. .............. ..........* ...* *..*. @@1/1 S 52J <= / W 8X @@1/1 S 52J <= 2Q 2
?.3..?. T2 1n5...................... 1n5................................... .......................... .......................... .......................................... .............................?' ?' ?.3..3. HX:...................... HX:................................... .......................... ......................... ......................... ...................................?' ......................?' ?.3... Go/...................... Go/................................... .......................... .......................... ......................... ......................... ........................?' ...........?' ?.3..^. p Rq 55 5Q4 R2 PLlj,L.................... PLlj,L..........................................................?' ......................................?' ?.. Tr 5s @@1/1 1\@ O\F5Rb........................ O\F5Rb.................................... ......................... ..............................?' .................?' ?..*. Te: 2/4 :=1 m 24 2e 1f @ \@@1/1 O\F5Rb\@@1/1.R.................... O\F5Rb\@@1/1.R................................. ......................... ........................6t ............6t ?..^.?. T>@ O\F5RbBF5@@\.R.......... O\F5RbBF5@@\.R....................... ......................... ......................... .............................6? ................6? CH()NG 3. PHÁT HI}N VÀ PH~NG TÁNH OOTKIT...........................6 3.*. P2c v2v v21 2/ \@@1/1........................... \@@1/1........................................ .......................................6 ..........................6 3.*.*. ,4•1...................... ,4•1................................... .......................... .......................... ......................... ......................... ............................6 ...............6 3.*.?. T2b@ €/ 55 [ /............................ /...........................................................................6^ ...............................................6^ 3.?. P2 P2  1\2 @@1/1..................... @@1/1................................. ......................... ................................................. ....................................6^ 6^ 3.3. M=1 m v2‚ :9: v21 2/ @@1/1.......................... @@1/1.........................................................66 ...............................66 KẾT LUẬN.................... LUẬN................................. .......................... .......................... ......................... ..............................................6" ..................................6" *. %2 / J1 4h <>1 <|5................................... <|5................................................ .......................... ............................6" ...............6" *.*.V9 J1 4h 4 h 1e: 2/4 Rq 124J1.............................. 124J1.......................................... ....................................6" ........................6" 4

*.?. V9 J1 4h 5X/
5

&T T * ? 3  ^ 6 7 " ' *t ** *? *3 * *^ *6

C"C THUẬT NG# VÀ VI$T T%T C'( )*+) -  -* ADA API CKPT DBA DBƒ H%H Oj j GA LGƒ\ jMON PMON PF5Fb jkj j,L PLlj,L V/by

Ns d Rv 1\e2 G/F@ / Rv 1\e2 C2b5v@/1 v\@5b ,49 1\@ O\F5Rb DF1FYFb y\/1b H
6

3ANH M!C C"C 45NG Bh *. DF1F /51/@F\ 8/by.................................. 8/by............................................... .......................... ...............................?3 ..................?3 Bh ?. Bh DF:/5 vb\…@\:F5b 8/by.........................................................? Bh 3. P2Q Y/1 F1F /51/@F\ 8X F:/5 vb\…@\:F5b 8/by....................?^ Bh . M=1 m 1b: v\/8/Rbb........ v\ /8/Rbb..................... .......................... ......................... .......................................?6 ...........................?6 Bh ^. ,49 2 12m YF 8X @vb\............  @vb\......................... ............................................?6 ...............................?6 Bh 6. M=1 m \@Rb \@ Rb O\F5Rb <2 2EF.............................. 2EF............................................................... ................................. ?7 Bh ". j[ 1c <† /dF DF1FYFb 8X Oj.....................................................3t Oj.....................................................3t Bh '. V/by V/by DBA‡ˆ@Y...................... DBA‡ˆ@Y................................... .......................... .......................... ......................... ........................3* ............3* Bh *t. V/by YF‡‰@Y‡\4/...................... YF‡‰@Y‡\4/................................... .......................... .....................................3? ........................3? Bh **. VŠP\@5b........................ VŠP\@5b..................................... .......................... ......................... ......................... .......................... ..................33 .....33 Bh *?. VŠjb/@..................... VŠjb/@.................................. .......................... .......................................................... .............................................3 3

7

3ANH M!C C"C H6NH V7 He2 *. K/J 1\a5 O\F5Rb........................ O\F5Rb..................................... .......................... ................................................ ...................................*6 *6 He2 ?. K/J 1\a5 8W 20 jGA...................... jGA................................... .......................... .....................................*7 ........................*7 He2 3. K/J 1\a5 DF1FYFb Y4……b\ 5F52b............................................................*7 He2 . K/J 1\a5 b@ R@ Y4……b\......................... Y4……b\...................................... ......................... ......................... .....................*" ........*" He2 ^. T/J T/J 1\e2 DBƒ..................... DBƒ.................................. .......................... ......................... .....................................*" .........................*" He2 6. K/J 1\a5 DF1FYFb........................ DF1FYFb..................................... .......................... ............................................ ...............................?t ?t He2 7. T\05 2/ 12F @ 4b\......................... 4b\..................................... ......................... .......................... .............................................. .................................* * He2 *?. G 49......................... 49..................................... ......................... .......................... .......................... ......................... .................? .....? He2 *3. %g 2v......................... 2v..................................... ......................... .......................... .......................... ......................... .................3 .....3 He2 *. T\4 8r......................... 8r...................................... ......................... ......................... .......................... .......................... .................... ....... He2 *^. %g 2v......................... 2v..................................... ......................... .......................... .......................... ......................... .................^ .....^ He2 *6. T>@ 8/by..................... 8/by.................................. .......................... ......................... ......................... ....................................6 .......................6 He2 *7. T>@ @:........................ @:..................................... .......................... ......................... ...................................... ..........................7 7 He2 *". %g 2v R>/ 4b\........................ 4b\..................................... .......................... ......................... .............................." .................." He2 *'. T\4 8r 1] / W......................... W..................................... ............................................. .................................' ' He2 ?t. %g 2v Yz 4b\ j1b: 8X 1>@ Yh N2Q V/]....... V/].........................^t ..................^t He2 ?*. T>@ Yh 2/........................ 2/.................................... ......................... .......................... ........................................^* ...........................^* He2 ??. T\4 8r d R/4 1\@ Yh N2Q V/].............. V/]...............................................^? .................................^? He2 ?3. T2F
8

L8I N9I :;U @@1/1 1\@ Oj 2s 5 ‹F R> 80/ 52a 1F. C2a <; <|5 55 Œ ‹Q: 2v  n < 52b /r4 55 r4 8J1 1f \r1 RQ4. T4 2/]„ 2s v2h/ F/ 5 Y/J1 \z \@@1/1 \@@1 /1 5 5o 12 <|5  n 8X : I1b\b1. Lr 5v 12s 1/ <; 1\S 12X2 :=1 4 5c 522„ 12s 1/ <; 1\S 12X2 :‘ 8X 52@ 1=/ v2>:. T2s 1/ 5 2Q <|5 52/F 12X2 2/94 R@>/ 80/ :5 / 25 2F4. V n„ 12s 1/ 89 <F 52Z„ m /„ X /2„ m 52 8n ‹; 2=/„ m :. N2r1 RX 55 Q 2X„ 2X Yg„ 52 8n 12Œ 12F2 1@ 2 CF\j1b:„ C/1/\@4v„ C/1/\@4v„ BF @… A:b\/5F„ A:b\/5F„ Djƒ j2@b ƒF\b2@4b’ ƒF\b2@4b’ <94 <; Y 1=/ v2>: 2: o 8X Q \F 12/1 2>/ 2r1 <2. O\F5Rb RX 2; { <‚4 1\@ 12 1\ 5c S d R/4 8X 12 <|5  n S 55 5c 4F„ 1x 525 R0. V0/ 2m/ R| d R/4 R0 8X 4F 1\Ž. K2s 2/  e„ O\F5Rb <; 1\S 12X2 <52 : 2rv { 1\@ 55 54=5 1r 5s. O\F5Rb F1FYFb \@@1/1 RX 20 1r 5s 2 :0/. @@1/1 <|5 5X/ / “ \r1 < . K2/ :X 5c S d R/4 RX :=1 1X/ 4] 8s 5W 4F 1\Ž 5o q 2EF m 5 /„ g 5v 12s 1/... T4 2/] 1 <= 1\@ 2 12m 8X ‹oF Y‘ r4 8J1 1\4 5v X 5X 1/2 8/. M=1 1\@ m ). R<<)=>). V n
2F2 52o 8X X :=1 1/2 8/„ 2d g: ‚ / V/1 NF: 12e 1X/ R/4 8X 2/4 Y/J1 89 @@1/1 5 2 2> 2–v ] 2o: 52a b: <; 12[5 2/ <9 1X/ X < 2/4 Y/J1 12]: 89 @@1/1. N=/ 4 <9 1X/ †: YF 52c C*?@- 1. T- B+- D R<<)=>). G/0/ R<<)=>). G/0/ 12/4 524 89 :; <=5„ @@1/1„ 552 125 2@>1 <= 8X v2Q R@>/ @@1/1. C*?@- 2. T- (F- R<<)=>) )<- O( O( .G/0/ 12/4 89 2 4h 1\ O\F5Rb„ 1r 5s @@1/1 1\@ O\F5Rb C*?@- J. *') *>-  *- )'-* R<<)=>). C5 v2c v2vv21 2/ 8X v2 52m @@1/1. N2o: b: b : ‹/ 52Q 12X2 5h: c 5s N4— T2 H† HX <; 1 1e2 52Z Yh@ 8X /av <˜ 2o: b: 2@X 12X2 <9 1X/ X.  X. D@ 12/ /F 5o 2> ] <9 1X/ 2/] 54 5F 2o: b: 8{ 5 2/94 12/J4 o1. N2o: b: :@ 2 <|5 [
10

CHPQNG 1. TNG SUAN V ROOTKIT ..Giới thiệu chung v/ m0 12c h3i M; <=5 2>/ šMFRyF\b› 8/J1 11 5F :FR/5/@4 @…1yF\b. M; <=5 RX :=1 R@>/ v2‚ :9: 2 12m @ 55 1F 1/ 1i5 2F 55 Œ 252 |: 1>@ \F 2z: :n5 <52 1\4 5v„ 52Z2 F 8X v2 2>/ 55 v2‚ :9: 25 1\] : 12. M; <=5 †: 2/94 R@>/ V/\4„ jvyF\b„ T\@‰FlBF5@@\„ AyF\b„ ƒ@\:„.... 8X 55 Y/J 12 25 ‹4r1 2/ 1f X. X. Mn5 1/]4 5F :; <=5 5o 12 RX 12s 1/ 5 2Q„ d R/4„ 1X/ 4]„ : 12... Yz 552 2/ r4 55 12o/ 4b R01 ƒbY 5F Y>„ 52a Y/J1 2d 8r <9 Y> 4F 1Q: 8X 2d 4h 5@ :X “ v2W 2|v 80/ q <2 5F Y>. N2d :; <=5 X 52@ v2•v 55 5s 1 4h 5@ 12/J1 J 55 v@v 4v : Y1 :n5 <52 5F 1f 5 2Q. pF 2c dF„ :; <=5 5o 12 . %o RX 2F5/. C5 =/ 4 1e: /J: 8X 2/ 12 5F Y> 5o 12 Y 2F5/ F 1\F :X :FRyF\b 52Z <2. %/94 X 5o 12 <F . Mn5 1/]4 12 YF„ RX 12s 1/ 5 2Q. N2d 12s 1/ W < ) K 1241 @@1/1 12[5 \F 2s v2h/ RX :0/. No <; 1† 1>/ ‚ :/ :r g:. %‚4 1/] <|5 v21 1\/ 1\] 2 1 <= 5F o. C2@ 10/ [ /
@@1/1 ‹h \F X 3*l*tl?tt^ <; <F \F \@@1/1 12X2 1\4 1Q: 52a q. No 5 52 1‘„ 2; <; 2/] 5F 8X v21 1\/  1241 \@@1/1 4 5. jF4 [ / X„ j@ <; v2h/ 1/J 2X2 ˜ Y‘ \@@1/1 1\] / 55 /4 4 5c 5o 12„ 12e 2d / 1>@ \F :; <=5 5 “ 1c  <v R>/ Yz 55  1241 g 5v 8X 1/2 \F2 2c. Bz Bz 552  n \@@1/1 \@@1/1 8X 2h g R• Ra1 5F o„ 2d 2d 1/ 1i5 : 12 <; 1e: \F 552 :0/ :0/ RX 2/4 4h < 1r 5s. C5 C5 52c 1\e2 1\e2 52b /r4 \@@1/1 52@ 12r :=1 4 5c 5 9 89 F /2. T2[5 1J„ X 6l*?l?tt^ 6l*?l?tt^ 1>v 52 bybb <; 5s Ym \z 5o 10/ ?tž :FRyF\b :FRyF\b Y v21 2/ 1\] ƒ/@y pP jP? RX 55 \@@1/1 1\@ m 55 :FRyF\b RX *ž„ 1\@ 2/ 1>/ 12/ / …/Rb 2 12[5 \F o 8{ 2@>1 <=. @@1/1 12 RX Œ ‹Q: 2v W F4 2/ 52/J: <|5 49 1\4 2v 8X@ 2 12m : 12. C5 5s 5n X 12 2z: < 52b r4 d R/4 2 12m„ 1v 1/ 2@i5 1/J 1\e2 „ 1f  :; 52@ v2•v 1† 1>/ :=1 552 Y9 8d„ RQ4 X/ 8X ‚ 2 2s 12 v21 2/ 1\] : 8/ 12. @@1/1 5o S 2/94 R@>/ 2 . K2/ 55 5s 2 X J1 2|v R>/ 12e \@@1/1 1\S ] ‚ 2 2s 12 v21 2/ <|5. @@1/1 2s :F 2EF ‹r4„ 8X 2s v2h/ 12 <|5  n < Rr 1\=: 12s 1/ 5 2Q T241 d Ÿ\@@1/1 Ÿ\@@1/1 Ra5 <‚4 <|5 W <9 52Z :=1 Y= 5s 5n U/‹ <|5 Y/] 52 R>/ 2 Ÿv„b11F1„y F vFy 5o 12 52b /r4  R˜ 8J1 152 5F Œ ‹Q: 2v :X Ye2 12 “ Y 2/ 12 YS/ 55 R2 1\]. Ve 8 o 52@ v2•v Œ ‹Q: 2v 4 1\e 49 Ÿ\@@1 1\] 2 12m :X F 5h / 4h 1\ 2 12m 5 2s 12 12r 2Ž. NX F 1241 d X 2s 52Z /0/ 2> S 55 2
.7. 89ch thc h(3t 12ng c;< 5((t6it 1.J.1. C*>XY B+ZD- [>D+ =*>\Br1 ¡ 2/ X@ / W 2F :=1 52c 1\e2 X@ 5‚ 1\4 8r 2 12m„ J1 4h 1\h 89 “ <|5 :i5 <2 1/ 1S 2s | 52a1 2/ 8r . @@1/1 R|/ n [ 1/ 1S 5c Yh X. %‚4 1/] o v2h/ 52/J: <|5 49 4h 1\ 2 12m < 5o 12 - LX  1241 :X @@1/1  n < 12F / 5F o. H@@ “ 524 20 55 52c 1\e2 Ye2 12„ F 55 2X: 5F \@@1/1 12F 8e 55 2X: 5F 2 12m. Ch 52J <= 2Q 2 / 5F o. C5 52c 1\e2 X [F 1\] 12s 1/ Rr 1f Oj. C2a 1F “ 2s v21 2/ <|5 \@@1/1 12s 4F 55 5s 5n 2 TF MFFb\„ y/@y b‹vR@\b\ 2F \bb/1. ƒ/@y  n 55 Yh < R4 1\d 8X 2/ r4 55 12s 1/ 4F 1\Ž. C5 Yh X 5o 12 Y 2@@„ 12F / Y 2> 52J YS/ 2d e :X 52a 5o 12 2@@ @ v2>: 8/ 2@>1 <= 5F 52a. @@1/1 S 52J <= / W 52Z 5o 12 2@@ 55 Yh 1\@ v2>: 8/ 2s /F <F 52Z X2 52@ / W š55 Yh IAT„ ÀT› 2@i5 5o 12 52¢ 55 ‰4:v 8X@ API :5 4b\ < 12F 55 R/ Ž/ 2 12m F 2X: 5F \@@\/1. Co 2F/ /4 2@@ RX 2@@  < 5o o 5o 12 2@@ 2@@  API 1c  5F 52c 1\e2 1 ] 4b\ :@b \@@1/1 1 2/4 4h Yz \@@1/1 S 52J <= 2Q. 13

@@1/1 S 52J <= 2Q 52Z 5‚ 2@@ :=1 5r4 1\a5 :X 1r1 5h 52c 1\e2 / W  n .=. >h,n ?(3i 5((t6 (t6it @@1/1 @@1/1 <|5 v2Q R@>/ [F 1\] [ 4 1\e F4 2/ 2S/ <= R>/ 2@i5 2@>1 <= S 52J <= / W 2F S 52J <= 5rv 2 12m. 1.^.1. R<<)=>) _ (*X [` -?a> bc-  R<<)=>) _ (*X [` -*d- * [>D+ *-* 5((t6it @ ch% 12 ngưAi dBng: N2d dBng: N2d \@@1/1 X “ F š52Z2› 55 1/J 1\e2  1\@ Y= 20 8X 4F „ o “ Ž/ :=1 2X: ƒ/@y API š`4:P\@5bb› 8X 2 89 F2 52 55 ID 1/J 1\e2 <|5 Rr 1f :=1 5r4 1\a5 d R/4 5F 2Q. N2d 2X: X 5 <|5 Ž/ YS/ 55 52c 1\e2 1\e2 4h Rq 1v 1/ 5F ƒ/@y 2 `‹vR@\b\ < R/1 ] 1@X Y= 55 12 :n5„ 1v 1/ 2 12m. K2/ :=1  n 12[5 12/ R/1 ] F2 52 12 :n5 8X 55 1v 1/ 5o 12 52F \@@1/1„ 55 \@@1/1 X “ 52i 55 2X: X 8X 12F / Y‘ 55 1v 1/ 52F \@@1/1 2‘/ F2 52 R/1 ]. N2d \@@1/1 S 52J <= / W v25 1>v 2c “ 52i 55 1v 1/ 2 12m„ b/1\„ 8X 55 2X: R/1 ] 55 1/J 1\e2 1f 55 2X: API 2 12m. C5 J1 m/ :> 5o 12 <|5 /r4 Yz 2d v2c v2v 1c 1[ 2F4 Yz 552 12F / 2s 12 v21 2/ \F. 5((t6it @ ch% 12 nh,n: @@1/1 52J <= 2Q 4 2/: 2c 55 R@>/ 1\]„ 52a 2s 52Z 52i 55 2X: 2X : API API 2 12m :X 5 5o 12 12F@ 15 1\[5 1/Jv 55 5r4 1\a5 d R/4 1\@ 52J <= 2Q. C5 \@@1/1 S 52J <= 2Q 12e 5‚ v2h/ 5o 12]: :=1 m <@> :; < 5o 12 <|5 >v 8X@ 2Q š12 RX :=1 1\e2 1 <|5 :n5 <52 X„ 52a 52a 5o 12 12b@ 1\e2 1[ 2|v R :X 55 1\e2  :; 5o 12 52Z2 F 55 J1 4h 1\h 89 1f R/ Ž/ 2X: Y] 1\@ R€/ 2@i5 52Z2 F 522 55 5r4 1\a5 R€/ H%H. M=1 E 1241 524 52@ 8/5 œ rv 55 1/J 1\e2 :; <=5 RX R@>/ Y‘ 55 1/J 1\e2 X \F 2‘/ F2 52 55 1/J 1\e2 S 52J <= 2Q. BS/ 8e 55 2X: API 4h Rq 55 1/J 1\e2 <94 v2h/ v2n 124=5 8X@ =/ 4 1\@ 55 5r4 1\a5 d R/4 X„ ] 2/ \@@1/1 12F
1\a5 d R/4 2 12m 12e 55 5s 5n 2 TF MFFb\ 2@i5 P\@5b `‹vR@\b\ 5 2s 12 v21 2/ <|5. M=1 8 n @@1/1 5@v :=1 Yh F@ 5F 52a 80/ 1] :FRyF\b.b‹b 8X v.RR 5 2 :=1 v2‚ 5F 52a 8X@ :=1 12 :n5. jF4 / 2Q < 2d 12X2 12X2 v2‚ 52a 8fF 5@v 5@v 2s Y v21 2/ dF dF š5h 80/ y/@ywb‹vR@\b\ R{ :=1 52c 1\e2 …/Rb:FFb\ Yr1 ¡. C2a 2@X 1@X Ÿ1X 2e2 8X 0/ 5/ Rm1 / . 1.^.2. R<<)=>) eD- ef ef  R<<)=>) R<<)=>) bg )h- e` -*i 5((t6it C/n CD: RX :=1 R@>/ \@@1/1 J1 2|v 80/ 55 :; <=5 25 2@>1 <= :”/ 2/ 2 12m 2S/ <=. BS/ 8e 55 :; <=5 52F :; v2 2@>/ “ <|5 12[5 12/ 1[ <= :”/ 2/ 2 12m 2S/ <= 2@i5 2/ /  n  :; 12[5 12/ 52c 1\e2 1\@ b/1\„ 55 1v 1/ 2 12m 8X 55 v2c v2v 52@ v2•v Q: 12‚: 52> 55 <@> :; :X /  n 2s 2F Y/J1 . 5((t6it dự< tEên C2 nhớ: R@>/ \@@1/1 X 522 RX 55 :; <=5 2s 5o 2d <@> :; ¥F/ ¦¥ ¦¥ w 52Z R4 1\@ Y= 20„ 522 522 8e 12J R@>/ \@@1/1 X X 2s 1† 1>/ F4 2/ 2S/ <= R>/ :.

15

CHPQNG 2. TẤN CÔNG ROOTKIT TRONG ORACLE 4.. Giới thiệu v/ 6i%n tE&c FE
Hj-* 1. K>X- )k( O( M 52 O\F5Rb RX :=1 2 12m 4h 1\ 5c S d R/4 - (l O( T2 2/ 5F O\F5Rb YF@ †: :=1 5r4 1\a5 Y= 20 2 12m 8W 5n5 Y= šjGA› 8X 55 1/J 1\e2 9 šYF5\@ šYF5 \@4 4 v\@5bb v\@5 bb› › <|5  n < 4h 1\ 5c S d R/4. T2 2/ 5F O\F5Rb <|5 ‹5 <2 4F 12F: m :s/ 1\ OACL`‡jID 5F 2
16

Hj-* 2. K>X- )k( c- -*i &GA jGA RX 8W Y= 20 52/F Œ <|5  n < R4 1\d d R/4 8X 55 12s 1/
Hj-* J. K>X- )k( 3)e e+mm ((* B= <: œ 5c S d R/4 š DF1FYFb Y4……b\ 5F52b ›  K2/ 12[5 2/ :=1 1\4 8r„ 1/J 1/J 1\e2 : : 52 “ 1e: 55 2m/ 5‚ 12/J1 1\@ 1\@ 8W 20 <: d R/4. NJ4 2s 1e: 12r 2m/ 1\@ Y= <: œ 5c S d R/4„ 1/J 1\e2 : 52 :0/ <Ž5 55 2m/ 1f …/Rb d R/4 8X 1>@ R4s :=1 Yh F@ 5F 2m/
m DB‡BLOCK‡jI§`„ 52 1205 5F 8W <: 1\@ 8W 20 <: 5 <|5 ‹5 <2 YS/ 12F: m DB‡BLOCK‡BU¤¤`j.

Hj-* ^. K>X- )k( Rb< < e+mm b@ R@ Y4……b\ šB= <: v2n5 2†/› %|5  n 52@ 8/5  1e: R>/ 55 12F v R] <‚4 F4 2/ 8W <: <; <|5  n 2J1. C5 1/J 1\e2 9 12[5 2/ 55 525 g 12F 52@ R/ Ž/ 1/J 1\e2 ‹ Rq 1c . No
Hj-* n. T>X- )j-* 34o18

G2/ 5c S d R/4 šDBƒ› G2/ R>/ 55 12F / šLGƒ› G2/ R>/ 55 55 12F / 8X@ 55 …/Rb RX: R>/. G2/ R>/ RX :=1 1\@ 55 1/J 1\e2 9 5o 1\52 2/: 4h Rq Y= < RX: R>/ < 2/ R>/ 55 12s 1/ 1\@ b@ R@ Y4……b\ 8X@ b@ R@ …/Rb. G/: 1 2 12m šjMON› T/J 1\e2 /: 1 2 12m 12[5 2/ v2n5 2†/ 55 [ 5m 5 m F  F 1>/ 1 >/ 12/ 1 2/  1>: 12/ 2s 5 <|5  n dF 1\@ 4h Rq 1f / 55 /F@ 52 Y 52J1 :”/ 2/ ‹h \F [ 5m. jMON <94 / 1\> 12/ 5F 55 Yh 1 <=. PMON /: 1\F 1\> 12/ 5F c/ / 8X 55 b\8b\ v\@5bb„ 2S/ <= R>/ R>/ :”/ 2/ ‹h \F [ 5m. PMON PMON 5 5 12[5 12[5 2/ 8/5 8/5 . Tc 1[ 2 jMON„ PMON <|5 Ž/ / 1\> 12/ 5F 12s 1/ 1\@ /: @1 …/Rb 8X …/Rb d R/4 :”/ 2/ 5o 12F + O( Cc S d R/4 O\F5Rb <|5 ‹b: ‹•1 0/ 2F/ o5 <= 5r4 1\a5 R@/5 8X 5r4 1\a5 81 Rq. Cc S d R/4 O\F5Rb <|5 ‹5 <2 YS/ 1] :=1 1] 4 2r1 8X <|5 4 <2 1\@ 12F: m DB‡NAM` 5F 12s m. V9 :i1 81 Rq„ 5c S d R/4 †: 55 …/Rb
C5 d R/4 124=5 5r4 1\a5 R@/5 5F 5c S d R/4 2 55 Yh 2F 55 52Z m <94 <|5 R4 1\d 0/ > 81 Rq 1\@ 55 …/Rb d R/4 5F 5c S d R/4. w b@ b@ R@ R@ …/Rb M”/ 5S S S d R/4 O\F5Rb <94 5o :=1 1v 2|v 1f 2F/ \b@ R@ …/Rb 1\S R]. C5 \b@ R@ …/Rb 1\@ 5c S d R/4 12 <|5 Ž/ RX F1FY F1FYFb Fb© © \b@ \b@ R@. R@. M=1 M=1 \b@ \b@ R@ R@ < <|5 |5 1>@ 12X2 12X2 1f 2/94 2/94 \b@ \b@ b1\/b. C25 g 522 5F \b@ R@ RX 2/ R>/ 1r1 5h 55 12F / 5c S d R/4 1\@ 1\ 2|v 2 12m iv [ 5m 8X 2s 52@ v2•v 8/J1 1\[5 1/Jv d R/4 1\@ 5c S d R/4 R] 55 …/Rb d R/4 1\@ 5c S d R/4. w¤/Rb @ Rv 5c S d R/4.

Hj-* . K>X- )k( 3)e M”/ 2/ X@ :=1 12 2/ 5F 5c S d R/4 O\F5Rb <|5 :S„ / d R/4. 20

w I/1 …/Rb …/Rb %Q RX …/Rb …/Rb 12F: m 2S/ 2S/ <=. <=. Co > …/Rb …/Rb 8g Yh <|5 <|5 1>@ YS/ 4 1\e2 5X/ / <|5 1>@ ]„ 89 :i1 81 Rq„ YS/ :=1 2@i5 2/94 F1F…/Rb. K52 1205 5F :=1 1FYRbvF5b Yz 1x 52 1205 5F 55 F1F…/Rb F1F… /Rb 5F o 2@i5 Yz 1x 52 1205 5F 55 1FYRbvF5b 5F o. w L|5 <† šj52b:F› 8X R|5 <† @ Rv. Cc S d R/4  n„ 5rv v21 8X /h/ v2o 8W 2s /F R4 1\d 12s 4F 55 2m/ d R/4 O\F5Rb. `‹1b1 RX :5 v2Q 52/F 5F@ 2c 89 :i1 R@/5 55 8W 2s /F /F 1\@ 5c S d R/4. R/4. M=1 b‹1b1 b‹1b1 YF@ †: :=1 m m 2m/ d R/4 R/] 1/Jv 2F4„ 5W <|5 R4 1\d 1>/ :=1 12/J1 Y R4 /d. `‹1b1 <|5  n < R4 1\d 55 12s 1/ 5o 5W /4. jb:b1 RX :5 v2Q 52/F 5F@ 2c dF 89 :i1 :i1 R@/5 55 8W 2s /F 1\@ 1\@ 5c S d R/4. R/4. M=1 b:b1 RX :=1 1v 2|v 55 b‹1b1 <|5 5rv v21 52@ :=1 5r4 1\a5 R@/5. jb:b1 5o 12 <|5 v2Q 52/F 12b@ 2/94 R@>/ 25 2F4. w DF1F b:b1„ :”/ :=1 @w5R41b\b 1FYRb 5o :=1 F1F b:b1. C5 d R/4 1\@ :=1 Yh <|5 R4 1\d 1\@ 55 b‹1b1 124=5 F1F b:b1 / 1c  80/ :=1 F1F b:b1. M”/ CR41b\ 1c  80/ :=1 F1F b:b1. Dd R/4 5F 1r1 5h 55 1FYRb 1\@ 5R41b\ / 1c  80/ :=1 /b‹ b:b1. w @RRYF5 b:b1 :=1 2@i5 2/94 \@RRYF5 b:b1 5F F1FYFb <|5 21

1>@ Rv YS/ / 4h 1\ F1FYFb < R4 1\d 55 d R/4 1\4 /F v2n5 8n 52@ 8/5 2s/ v2n5 d R/4. C5 12s 1/ 1\@ @RRYF5 b:b1 <|5  n < 1>@ [ <† 2r1 55 12s 1/ <Ž5 <|5 1f 5c S d R/4 8X  n 1\@ 4 1\e2 2s/ v2n5 d R/4„ v2n5 2†/ R>/ 55 /F@ 52 52F 5@::/1 @ YS/ O\F5Rb :”/ 2/ :=1 5Q4 R2 j,L 1F1b:b1 5‚ / <|5 2@X 1\h 52@ 2 12m. O\F5Rb 12[5 2/ 5rv v21 8W 2s /F R4 1\d :=1 552 R/2 2@>1 :”/ 2/ 55 b‹1b1 5rv v21 <;  n 2J1. w C5 5r4 1\a5 81 Rq 25 N@X/ \F„ O\F5Rb jb\8b\ 5  n 55 …/Rb 25 < R4 1\d 12s 1/. C5 …/Rb  8g Yh. ª PFy@\ …/Rb …/Rb p5 <2 49 5F 1f / W 1\@ 5c S d R/4. C2@ v2•v /  n 2S/ <= 8X 11 :=1 O\F5Rb /1F5b. ª A\52/8b \b@ R@ …/Rb LX Yh @…… R/b 5F 55 \b@ R@ …/Rb 52F 55 12s 1/ 5‚ 12/J1 < v2n5 2†/ d R/4. C5 12X2 v2‚ X R>/ YF@ †: 55 @ YS/ / W. C5 D- b >+  =*+- -*j- *>+ -q- [`- 4..7.. hung nhIn tJ 1iKn dL ?iệu K24 2e 1f @ YS/ …/Rb 5\/v1 R.Y 1\@ 4 1\e2 1>@ 5c S d R/4. No †: 55 Yh 52Z <Ž5„ 54 5rv 12s 1/ 89 :Ž/ 2F 5>2 5F 5c S d R/4 O\F5Rb„ O\F5Rb„ 55 <2 2EF 89 R|5 <†
5v 21 :”/ 2/ 12[5 2/ R2 <2 2EF d R/4 šDF1F Db…//1/@ LF4Fb  DDL›. % Y/J1 24 2e 1f  52Z 2e 12r 55 12s 1/ 89 55 52b:F :X Y> S 2d4. V n Uj`‡TABL`j “ 52F 12s 1/ 89 55 Yh d R/4 5F Ub\ 2/ 12/. ALL‡ C5 1\4 8r 10/ 8/by 80/ 1/9 1m ARR ARR 52Z 52F 12s 1/ 89 5c S d R/4 5F / W
23

M=1 m F1F /51/@F\ 8/by T] V/by

N =/ 4 

DICTIONAk

T2s 1/ 524

DICT‡COLUMNj DBA‡TABL`j

T2s 1/ R/] 4F 10/ 55
DBA‡OBˆ`CTj DBA‡LOBj DBA‡TAB‡COLUMNj DBA‡CONjTAINTj DBA‡Uj`j

T2s 1/ 89 :5 49 5F Ub\

DBA‡jkj‡PIVj DBA‡OL`j DBA‡`pT`NTj DBA‡¤``‡jPAC`

Te2 2e2 5rv v21 2s /F 52@ 55
DBA‡j`GM`NTj DBA‡OLLBACK‡j`Gj

T2s 1/ 89 5r4 1\a5 F1FYFb

DBA‡DATA‡¤IL`j DBA‡TABL`jPAC`j DBA‡AUDIT‡TAIL

C5 12s 1/ /: 1\F

DBA‡AUDIT‡OBˆ`CTj DBA‡AUDIT‡OBˆ‡OPTj 4r- 1. 3) b>()><-Z >s

24

4..7.4. hung nhIn hiệu n$ng 12ng FE1 <=„ 8X =/ 4 5F 52a R/] 4F 10/ 2/4 g. Mi5 W 55 24 2e X 5o 8Œ 2 RX 55 Yh 12s 12 1\@ 5c S d R/4„ 2 12[5 \F 12e 2s. C5 24 2e X Rr 12s 1/ 1\] 5r4 1\a5 x
C2F 12s 1/ 89 522 F1FYFb 2 1]„ 12/ /F 1>@. C2 @ Y/J 1 v2/]  Y h < F  5X /. H/ H/ 12 12 55 55 12X 12X22 v2‚ v2‚ 1W 1W 52Ž 52Ž < <|5 |5 5X/ 5X/ 1\] 1\] F1 F1FY FYF Fb. b. H/ 12 12 12 12s 1/1/ 89 89 5 55 5Q 5Q4 R R2 j, j,L :X 4 4b\ <; <; 12 12[5 2/. L/1 L/1 ] 12s 12s 1/ 1/ 89 55 55 b b/ /@ @ 2/ 2/ 12/ 12/.. T2s  1/ 89   1b : R@ YF R F \ bF . T2s T2s 1/ 1/ 89 55 55 v\@ v\@5b 5b  2@>11 <= <= 2/ 2/ 1>/ 1>/.. 4r- 2. 4r- 3Z-Y>( m<Y-( >s

25

C2a C2a 1F 5o 12 12 v2 v2Q Q Y/1 Y/1 F1F F1F /51 /51/@ /@F F\ \ 8/by 8/by 8X  F: F:/5 /5 vb\…@\:F vb\… @\:F5b 5b 8/by 8/ by 2 2  F4 F4  DF1F D/51/@ F\  8/b y DBA‡ 8/by 12 5o 1] X/ š 8 n DYF‡F1F‡…/Rb› DYF‡ 8/by 52Z 5o :i1 2/ F1FYFb <; @vb 8X 52>

DF:/5 Pb\…@\:F5b V/by T] 5F VŠ 8/by 12  R/9 š8 n VŠDF1F…/Rb› M=1 m VŠ 8/by 5o :i1 2/ F1FYFb 52F <|5 @vb 2@X 1@X Dd R/4 12  S >  5 2d 2 @F Dd R/ 4 12   S >  5 2d 12 Dd R/4 RX 1E2 8X 2s Y ‹oF Dd R/4 <= = 8X :r1 :”/ 2/ 2/ Y 241@y F1FYFb 241@y 4r- J. *d- e>) b) b>()><--Z  bZ-Y>( m<Y-( >s 4.7. Muản tEị FE1 <= :5 2 12m 2 J1 m/ 10/ 5c S d R/4„ 1>@ Yh„ 52Z2 F 5c S d R/4. C5 / 49 522 RX  52J /4 5Q4 R2 j,L :X / W 5o 12 12[5 12/. %i5 49
%i5 49 2 12m RX 49 52@ v2•v 8 2X2 :5 5c S d R/4„ 2 J1 m/ @ / W„ 52Z2 F 5c S d R/4„  n 4 R| 5F 1FYRbvF5b. C5 5Q4 R2 <|5 12[5 2/ YS/ 49 2 12m 2 RX 55 5Q4 R2 DDL 2 C\bF1b„ FR1b\„ \@v„ 2F DML FR1b\„ bRb1b„ /b\1. O\F5Rb *t 5o 2c *7t 49 2 12m„ <|5 R/1 ] 1\@ 24 1f
AR1b\ F1FYFb„ FR1b\ 1b:„ F4/1 1b:„ F4/1 F C\bF1b„ FR1b\„ \@v„ b‹b541b C \ b F 1 b „ F R 1 b \„  \ @ v „  \ F  1 . C\bF1b„ FR1b\„ \@v„ bRb51 C\bF1b„ FR1b\. C\bF1bšF›„ \@všF›. C\ b F1bš F  › „ FR1b \š F › „ /b\1 b\1šF šF›„ ›„ 4vF 4v F11bšF šF›„ ›„ R@5šF›„ …RF2YF5šF›. C\bF1b„ FR1b\„ \@v„ :FFb.

 bR b5 1š F › „ bRb bRb1bšF šF›„ ›„

,4 9  < m/ 8 0/ 1FYRbvF5b ,49 ,49 >

O\F5Rb O\F5Rb 54 5rv 2F/ 49 2 12m 12m 1 <= F4 ,4 9 j   YF

H@>1 < =  j1F\14v„ 2 241@y F F1FYFb. C\ C\bF1b„ \ \@v„ F F1FYFb. T2/J1 Rv 55 52J <= YF54v„ \b5@8b\. T>@ v…/Rb. ,49 \b1\/51b b/@. C@b51 10/ F1FYFb 80/ 1X/ 2@h . K2/ J1 m/ F1FYFb 80/ 49 YF„ 52b:F 5F 4b\ RX .

27

j  @ vb\

j1F\ 14 v„  241 @y F1F YF  b. T2/J1 Rv 52J <= YF54v„ \b5@8b\ F1FYFb. ,49 \b1\/51b b/@. T2[5 2/ 55 2/: 8n 8 2X2 5c Yh„ 2s ‹b: <|5 d R/4 5F / W. K2/ J1 m/ F1FYFb 8X 5o 49 @vb\„ 52b:F 5F 4b\ RX v4YR/5. 4r- n. S+ZD- * )*u- Zbe  Z<

CW 80/ jYF 8X @vb\ RX :=1 49 5 \r1 :>2 RX bRb51 F /51/@F\ 52@ v2•v bRb51 1FYRb 124=5 55 F1F /51/@F\ 5F j„ 2 1FYRb TABŠ TABŠ 2F jF412Š. j F412Š. Ub\ S 2d4 55 @Y‰b51 8X 1b: v\/8/R/b 12s 4F 55 \@Rb. @Rb RX 1v 2|v 55 v\/8/R/ v\/8/R/bb <|5 2o: R>/ 2z: :n5 <52 4h 1\ — X. Co 12 12]: Y01„ ‹oF„ F 55 \@Rb \†/  52@ 2/94 4b\ 5W 5o :=1 \@Rb 12F 8e  52@ 1f 4b\ :=1„ 8X 5o 12 — X 124 2†/ \@Rb 89. O\F5Rb <2 2EF 1\05 :=1 m \@Rb. %o RX @Rb C@ C@b5 b511

,4 9  C\bF C\bF1b 1b b b/ /@ @„„ FR1b FR1b\\ b/ b/@ @„„ 5\bF 5\bF1b 1b  @ @ : :„ 5\bF 5\bF1b 1b 8/by„ 8/by„ 5\bF1b F1FYFb R/„ 5\bF1b 1FYRb„ 5\bF1b 5R41b\„ 5\bF1b b4b5b

b@4\5 b

C\bF1b 1FYRb„ 5\bF1b 5R41b\„ 5\bF1b b4b5b„ 5\bF1b 1\/b\„ 5\bF1 5\bF1bb v\@5b v\@5b4\b 4\b„„ 5\bF1b 5\bF1b 1vb„ 1vb„ 5\bF1 5\bF1bb /b‹ /b‹1v 1vb„ b„ 5\bF1b 5\bF1b @vb\F1@\ MŽ/ 49 5c Yh
DYF j@v @vb\ b\ j  YF

4r- . M`) u < O( [-* -* @Rb 4F 1\Ž 1\@ 2 12m RX \@Rb DBA. %o RX \@Rb <|5  52@ 4b\ j 8X j1b:. @Rb DBA 52F 2/94 49 4F 1\Ž 2 2s 5o 49 jYF 8X @vb\. ,49 1\] 55 \@Rb \r1 :>2. NJ4  49 G\F1 F \@Rb 52@ 4b\„ 4b\
28

29

2.J.2. T> =*@ 5c S d R/4„ 4b\ jkj <|5 1>@ 1[ <= 5W 8X <|5  \@Rb DBA. M1 2œ4 :i5 <2 RX 52Fb‡@‡/1FRR. %Q RX 1X/ 2@h S 2d4 5c S d R/4 8X 1f @ 55 1FYRb 2F 52Z2 F e 1\@ 52b:F 5F 4b\ jkj. DW 5o 12 12F =*@ 2/ 1>@ F1FYFb 8X o 5 <|5  \@Rb DBA. Ub\ 1b: 12 S 2d4 55 1FYRb @ O\F5Rb 54 5rv 2c RX 55 /51/@F\. Ub\ 1b: 5o 12 1>@ 12]: 55 1FYRb 8X 8/by < 54 5rv 12s 1/ 4h 1\ 5 2 89 55 1FYRb 8X 8/by <|5 W YS/ 55 5s 5n 4h 1\. K2s ] 1>@ 55 @Y‰b51 Yz 1X/ 2@h X. 2.J.^. L/&SL  Y`) u =*'> ->Y j,L  s d 1\4 8r 5r4 1\a5w RX 552 125 2F W < 1\4 2v < Rr d R/4 1f 5c S d R/4. j,L 52@ 52a 1F 2h g 1\4 2v 2@X 1@X 8X@ d R/4„ 15 RX 5o 12 Rr :Ž/ 12s 1/ W 5o 12 12s 4F 552 125 2s Rq 1S R:. j,L 2s 5o [ / :=1 12/ / R„ 2s RX: 8/5 80/ 55 Y/J„ 55 12F: m„ @Y‰b51„ \b5@\„ F\\F„ 5@ 1\‘„ ’ DW j,L 2 RX :=1 5s 5n :>2 :“ 2 o 8{ 52Z RX :=1 v2c v2c  125 1\4 2v F1FYFb F1FY Fb 2c RX :=1 s d Rv 1\e2. 1\e2 . PLlj,L PLlj, L 25 v2n5 2d 2|5 @ 55 v\@5b4\b„ …451/@„ 1\/b\„ 8X @Y‰b51 <|5 R4 1\d 1\@ O\F5Rb. No RX 8/J1 11 5F P\@5b4\FR LF4Fblj,L 8X [F 1\] s d Rv 1\e2 ADA 8X RX :=1 :S \= 5F j,L„ J1 2|v 8X@ 1\@  :; 5o 5r4 1\a5 2m/ 8X 12 12 1n5„ RX: 52@ PLlj,L 1\S 12X2 :=1 s d ‹ Rq 1\FF51/@ :>2 :“. 4.7.=.. hi nOc d/ 55 F@:@4 F@:@4 YR@5 YR@5 5@b„ 5@b„ v2h/ R4 o R>/ 12X2 …/Rb 8X 52> R>/ 2@i5 12]: o 8X@ :=1 52c 1\e2 25. K2m/ >5 F2 Rq 1S 52@ 8/5 12[5 2/ 55 5s 8/5 2s v2h/ Riv 30

R>/. No Y1 <‚4 Yz Db5RF\b 2@i5 Yb/. 4.7.=.4. Th; tPc T2 1n5 šP\@5b4\b› RX 2m/ R2 <|5 /. T2 1n5 <|5 / 12/ @„ 8X :i5 <2 / S 2d4 RX / 1>@ o. Co 12 12[5 12/ 55 12 1n5 1f r4 25 j,L°PR4„ 1f Y] 1\@ :=1 :; j,L 2@i5 1f 2m/ R2 PLlj,L 25. 4.7.=.7. Hàm HX: 5 RX 2m/ 5@b <|5 R4 1\d 8X @ 8X Y/] 52 1\05 v2‚ Y@. Co Co 12 1>@ 55 o/ 80/ v2‚ UM K2/ K2/ 12[5 12/ := :=11 2m/ PLlj, PLlj,L„ L„ R2 R2 <|5 524 524 10/ PLlj, PLlj,L L b/b. `/b 5o 12 S 1\@ 522 : 52 d R/4 2@i5 RX :=1 1\@ 55 1@@R 5o 152 2|v PLlj,L b/b. T/Jv 12b@„ 5@b <|5 v2Q 152 5a v2v 12X2 :; j,L j ,L 524 524  10/ 1 0/ j,L j ,L b/b b/ b 2@i5 2 @i5 j,L 1F1b:b 1F 1b:b11 b‹b541@ b‹ b541@\. \. C5 5Q4 R2 12 1n5 <|5 524 10/ c/ 12[5 12/ 12 1n5 < ‹ Rq. C5 R2 PLlj,L 5o 12 <|5 /1b\v\b1„ 15 RX 55 12 1n5„ 2X:„ o/ <|5 Y/] 52 8X R4 1\d S > PLlj,L F4 . £ 52J <= /1b\v\b1b„ Y/] 52 PLlj,L 2F2 2c 2 8/5 12[5 12/ 5@b 52: 2c @ 80/ F1/8b 5@:v/RF1/@. NF1/8b 5@:v/RF1/@ 5@:v/ RF1/@„ „ 5o :i1 <‚4 1/] 1\@ v2/] v2/]  Yh O\F5Rb O\F5R b '/* 8X <|5 5h/ 1/J 1\@ *t*. No 524 PLlj,L 12X2 C F 1>/ 12/ / 12/ . 4.=. T!n cVng 5((t6it tE(ng FE: 8/ 5F Oj F R;2 <F 5F 5c S d R/4 O\F5Rb. 31

32

M=1 m [ 1c <† 89 5@::F 8X @Y‰b51 /dF O\F5Rb 8X Oj°N/‹ °NIp C@::F l OY‰b51 Pj K/RR *?3 `‹b541FYRb

O\F5Rb 5@::Fl OY‰b51

bRb51 ° …\@: 8Šv\@5b AR1b\ 1b: /RR b/@ ©*?„^^¯ V/by„ PF PF5Fb„ P\ P\@5b4\b F F  ¤451/@ `‹b541b jbRb51 ° …\@: 8/by± b‹b5 v\@5b4\b C FR1b\ b/@ b1 54\\b1‡52b:F²4b\t* : DbRb1b YFR...šv41 / 5@\\b51 1F‹› ¤/ D\@v 1FYRbvF5b 4r- w. &g )?@- [x- > 3)e  O&

T2s 12 12 5o :=1 12 1241 5F @@1/1 Oj 12J 2 <‚4 1/] 2/ œ :=1 2@h R2 S 1\@ Oj°NIp 2 v„ y2@ 8X 1@v <; Y 12F 12J Yz v2/] Yh 5F T\@‰F„ R/1 ] 1r1 5h 1\f 1X/ 2@h 5F Œ ‹Q: 2v. H0 1/Jv 5 X 5 5o 12 <|5 v n 1 <= 5F 4b\ 1\@ DB. VX 1e: 2/4 :=1 m o/ PLlj,L  5o 5F O\F5Rb <|5  n 52@ 8/5 1r 5s 5F 1/ 1i5. 2.^.1. TjY *>\+ Y`) u =*+- -*j- )p [>\- b >+ 34AyzO4& V/by V/by YF‡‰@Y R4 12s 1/ 89 1r1 5h ˆ@Y 1\@ 5c S d R/4. T2s 1/ 89 55 5=1 1\@ 24 2e X

33

C@R4: ˆ@Y L@‡4b\ P\/8‡4b\ j52b:F‡4b\ LF1‡F1b LF1‡b5 T2/‡F1b T2/‡b5 Nb‹1‡F1b Nb‹1‡b5 T@1FR‡1/:b B\@5b I1b\8FR ¤F/R4\b ƒ2F1 NR‡b8 M/5‡b8 I1F5b

C@::b1 p5 <2 :=1 ˆ@Y. K2s 12F / Ub\ 5o 49 :i5 <2 <|5 v n 52@ ‰@Y X j52b:F :i5 <2 <|5  52@ :=1 ‰@Y 2/ 12[5 2/ T2/  ‰@Y X. NJ4 RX N 5o :=1 m 5m  < 52> ‰@Y Lv R52 52> ‰@Y R‚ 1/Jv 12b@ jm R‚ 2S/ <= ‰@Y 8X 2s 12X2 5s  1f R‚ 12X2 5s ‚ 2r1 B@ 5F YR@5 F@:@4 PLlj,L :X ‰@Y X 12[5 12[5 2/ 2/ T2F: m v2/] :s 1h Y/J :s/ 1\ R 5F ‰@Y T2F: m v2/] 25 v n 52@ ‰@Y ID 5F /1F5b 52> 2@i5 5o 12 52> ‰@Y. Mi5 <2 RX t 4r- {. V>s 34Ayz
34

34AyzO4yRUNNING V/by V/by YF‡‰@Y‡\4/ R/1 ] 12s 1/ 89 1r1 5h ‰@Y  C@R4:‡F:b ¤F/R4\b I1F5b ˆ@Y LF1‡F1b LF1‡b5 jI D T2/‡F1b T2/‡b5

C@::b1 jm R‚ ‰@Y <|5 2S/ 2@>1 8X 12r1 Y>/  1f R‚ 12X2 5s F4 5W ID 5F /1F5b 52> ‰@Y ID 5F ‰@Y  NX ‚ 2r1 5F ‰@Y 52> 12X2 5s Tc 1n RF1‡F1b„ V>s s bey}-

35

V~ROCE&& L4 12s 1/ 89 55 v\@5b 2/ 1>/  C=1 A\ P/ jv/ Ub\F:b T\F5b ID BF5\@4 LF152yF/1 LF152v/ PF‡4b‡:b: PF‡FRR@5‡:b:

Ms 1h %F 52Z 5F v\@5b %2 F2 5F v\@5b %2 F2 1\] Oj 5F v\@5b P\@5b <|5 52> Yz 1X/ 2@h Oj X@ %2 F2 …/Rb 1\F5b N2 / v\@5b 5o v2h/ 1/J 1\e2 YF5\@4 2s %F 52Z 5F LF152 :X v\@5b
36

VŠjb/@ R/1 ] 55 12s 1/ 89 :”/ b/@ 2/ 1>/„ \@@1/1 5‚ 1e: 552 52b /r4 12s 1/ 89 55 v\@5b S 1\@ 55 8/by X. M=1 m 12s 1/ 1\@ 8/by 8Šb/@ C@R4: jF\ j/ jF\/FR³

PF\ `8b1 j1F14 L@@‡1/:b Ub\F:b C@::F Tvb

N=/ 4 %F 52Z b/@ %2 > b/@ jm b\/FR 5F b/@. DW <9 ‹5 <2 4 2r1 :=1 @Y‰b51 5F b/@ / <2 F2 5F b/@ %F 52Z 5F v\@5b S 2d4 b/@ TX/ 4] 2@i5 [ / :X b/@  12/ 5F b/@ šF51/8b„ /F51/8b„ /RRb„ 5F152b...› T2/ /F R@@ T] 4b\ C5 R2 <-

2.^.2. K*> )*'( ('( •> L/&SL PF5Fb RX :=1 52b:F @Y‰b51 2o: 55 /4„ Y/J 8X 52c 1\e2 PLlj,L 5o R/] 4F . PF5Fb 12 5o 2F/ v2‚ v2‚ / R„ 5@ 1\‘ 8X 55 52c 1\e2 5@ :X Y] @X/ 5o 12 12F: 52/J4 10/. P2‚ Y@ <2 2EF 55 1\4 8r 52@ 5@ 1\‘ :X :; 52@ 55 52c 1\e2 5@ š 55 v\@5b4\b„ …451/@..›. P2‚ vb5 <|5 5@/ RX v2‚ 2=v 1\„ v2‚ Y@ RX 2=v @ vF5Fb vb5„ W R2 C\bF1 vF5Fb. L2 C\bF1b vF5Fb Y@ <2 2EF v2‚ Y@. P2‚ vb5 “ <|5 v4YR/5 80/ 1r1 5h 55 P\@5b4\b 8X 5@b 25 Y] @X/ vF5. P2‚ Y@ 52F 55 12[5 12/ 8X 2F/ Y@ \/]„ \ /]„ 2s <|5 2/ 12 34M&yMETA3ATA % 12F / 24 2e„ Yh. KŒ 1r 5s 5o 12  n o/ Y:‡:b1FF1F 5F O\F5Rb < Rr :; 4† šDDL› X. 37

T2[5 1J O\F5Rb <F \F o/ Y:‡:b1FF1F 2z: RX: / 55  pMI 2@i5 DDL. jF4  DDL < 1>@ R>/ @Y‰b51. DBMj‡:b1FF1F DBMj‡:b1FF1F  n :=1 m 1. Ve 12J 55 52c 1\e2 PLlj,L 52Z 5o 12 Rr /]4 d R/4 52@ 55
C5 5@R4: I1b:„ 8FR4b„ @Y‰b51‡\@y RTb‹1„vF\bI1b: b\\@\N4:Yb\„ b\ b\\@\Tb‹1 DR„ b\\@\R/b

2.^.J. C'( =*r -q- (l R<<)=>) 4.=.7.. Wn tài 6h(ản tEuy nhXY Ub\ O\F5Rb <|5 R4 1\@ 1FYRb jkj.Uj`Š 5W 80/ F1FYFb \@Rb. Ub\ 5o …RF TkP`³²* 8X \@RR 5o …RF 1vb ³²t. % 8/5 1\4 2v — X 2c 8X  1\] O\F5Rb›. jF4 / 24 2e 1\] “ 2s 12r ‹4r1 2/ 1X/ 2@h @. Ve 12J / Rv 1\e2 8X 4h 1\ 2s ] [F 8X@ 24 2e 2e :X ] 1\4 2v 8X@ 55 Yh 5g Yh 2 jkj.Uj`Š. 38

4.=.7.4. Wn ti%n tEInh T/J 1\e2 1\@ O\F5Rb <|5 52F RX: YF R@>/ w T/J T/J 1\e2 1\e2  // W W B1 <‚4 <‚4 2/ 2/ / / W W 5c S d d R/4 R/4 ]4 5‚4 5‚4 J1 J1 m/ 10/ 10/ : 52 O\F5Rb w T/J T/J 1\e2 1\e2 : : 52  p p Rq 55 55 ]4 5‚4 5‚4 1/J 1/J 1\e2 1\e2 / / W W ]4 5‚4 5‚4 J1 J1 m/ 10/ 10/ /1F5b. w T/J T/J 1\e2 1\e2 9 9 RX 55 55 1/J 1/J 1\e2 1\e2 1c 1c 15 R{ R{ 2F4 2F4 8X 80/ 2 2 1 <= VŠb/@ 1\05 8X F4 2/ œ 1/J 1\e2 5F 1/ 1i5. C5 1/J 1\e2 <|5 R4 1\@ 8/by 8Šb/@ z: S 52b:F j. N@X/ \F 12s 1/ 89 :”/ b/@ 5 ‹4r1 2/ 1\@ 8‡Šb/@„ …R@y‡b/@„8‡Š v\@5b. 4.=.7.7. Wn cZ s@ dL ?iệu t9c vP ˆ@Y RX 2d 15 8n 5‚ <|5 12[5 2/ 1>/ :=1 12/ /. Lv R52 52> ‰@Y /av 1[ <= 2oF 5s 8/5 4h 1\. V n Rv R52 4vF1b„ /:v@\1„ b‹v@\1 d R/4. T2s 1/ 89 1r1 5h 55 ‰@Y 5o 1\@ YF‡‰@Y„ ‡‰@YŠ„ YF‡‰@Y‡\4/. G/h  2F5b\ 5‚ 1>@ :=1 ‰@Y < 52> 1>/ :=1 12/ @ “ 52> Yz 49 5F 2F5b\. 4.=.7.=. +ó< ?istnE ?(g tE(ng FE1 R@/›. G˜ Y‘ 55 r4 8J1 5o 1\@ 55 …/Rb X RX / 12/ 1 <=. 4.=.7.Q. +ó< FE
N20 \z ‹oF 2F\b v@@R “ h2 2S 10/ 2/4 4r1 5F 5c S d R/4 8X / W 5o 12 “ 12F v2/9 89 1m5 <= 1\4 2v. 4.=.7.[. +ó< FE S 52J <= F\52/8b R@ 39

:@b. T/ T/ 1i5 5 “ v2h/ ‹oF 55 r4 8J1 X. %‚4 1/] 52> R2 < 524 5c S d R/4 :=1 \b@wR@ Alter system switch switch logfile;

jF4 2/ 5X/ ) 4.=.=.. Th1 <=. Cn 12„ 12s 1/ 89 4b\ 5o 1\@ .4b\Š„ YF‡4b\„ FRR‡4b\ T2s 1/ 89 Co 1\@ 1FYRb„ 8/by Ub\ j.4b\Š„ YF‡4b\„ FRR‡4b\ ˆ@Y DYF‡‰@Y„ YF‡‰@Y‡\44„ .‰@YŠ v\@5b VŠb/@„ 8‡Šv\@5b„ …R@y‡b/@„ 8‡Šv\@5b %‚4 1/] ‹b: 4† 5F 24 1\@ 8Š…/‹b‡8/by‡b…//1/@ 2 F4 Select view_defiitio !rom v"fi#ed_view_defiitio where view_ame $ %&"'(!)LE_*SE+S,;

TF <|5 Select *SE+NA-E. SYS/BA. SYS0'E+ from 1&"'(!)LE_*SE+S where ist_id $ *SE+EN& 2%)stace,3

N2 8r <9 RX 8/by GVŠPƒ¤IL`‡Uj`j RX …/‹b 8/by š8/by 5m <2›. O\F5Rb 4b\ YF@ †: 5h jYF 2s 12 12F
40

KJ1 4h  &)E(_/E!)N)T)0N Select ist_id. userame. decode2sysd4a.5.,T+*E,., decode2sysd4a.5.,T+*E,.,! !ALSE,3. /ecode2sysoper. /ecode2sysoper.5.,T+*E,.,!A 5.,T+*E,.,!ALSE,3 from #"67srt where userame ot i 2%)NTE+NAL,.,8AC9E+,3

Ve 12J„ 1/ 1i5 “ v2h/ 15 <= 10/ v2‚ 2 v2Q < @4\5b 5F 24 2e 5m <2 :0/ Y h2 2S„  n 5s 5n 2 2b‹b/1@\ bF\52 2@i5 1c 1[ < 1e: 524”/¯GVŠPƒ¤IL`‡Uj`j¯.

Hj-* w. T?i( =*> )*Z [> 4>-Z

Hj-* {. &+ =*> )*Z [> 4>-Z jF4
O\F5Rb “ v2Q /h/ 1] @Y‰b51 4b\‡F:b X 2 12J X@´ %‚4 1/] O\F5Rb /: 1\F ‹b: R/4 5o :=1 R@5FR @Y‰b51 š1FYRb 2F RX 8/by› RX DBA‡Uj`j. NJ4 5o„ @Y‰b51 X <|5 W 52@ 4b\. NJ4 2s O\F5Rb 1/Jv 1n5 1e: :=1 @:
Kiểm tra xem có object DBA_users !"#$% &'u có t!( s) *+#$, !"#$ có t!( t(m ti'-.

Hj-* |. :?a- b- )*g( )*> )<- O( w T>@ :=1 :=1 R@5FR R@5FR @Y‰b @Y‰b51 51 :0/ :0/ 80/ 1] /m /m 1\@ 1\@ 55 55 R|5 R|5 <†  // W W w T>@ T>@ :=1 @Y‰b @Y‰b51 51 :0/ :0/ 12F: 12F: 52/94 52/94 10/ 10/ @Y‰b5 @Y‰b511 YF <‚4 š8/b š8/by y 2F 1FYRb 1FYRb›› 2@i5 :=1 :=1 @Y‰b51 :0/ 52F Yh F@ 5F F1F 1\@ @Y‰b51 YF <‚4. Bh DBA‡Uj`j ] <|5 5v 21 80/ :=1 1\/b\ 1\] jkj.Uj`j w T>@ T>@ :=1 :=1 @ @: : \/] \/]  8X 8X :=1 :=1 R@5F R@5FRR @Y‰b @Y‰b51 51 :0/ :0/ w C2Z2 C2Z2 F F :=1 :=1 @ @: : 5s 5= 5= 8X 1>@ 1>@ :=1 :=1 @ \F \ F 55 / 1\f jkj.

42

#_ dP dm( YhưZng Yh9Y th C<: T3( m2t YEiv@ \F :=1 24 2e 8X :=1 @: 2z: 52b r4 / 1r 5s 80/ 55 / W 25 C5 Y05 1/J 2X2 4?i( 1‚ B1 1‚ B1 RlvR4 4?i( 2‚ %g 2‚ %g 2v 8X@ 2 12m 80/ 1 552 RX :=1 1/ 1i5  `1b\ 4b\‡F:b jkjT`M `1b\ vFy@\ *

Hj-* 10. :q- -* < * )*u-

4?i( J‚ T>@ J‚ T>@ * 4b\ HACK` :1 2œ4 RX ABC*?3 ABC*?3 43

C\bF1b 4b\ 2F5b\ /b1/…/b Y FY5*?3±

Hj-* 11. Tƒ< +

44

4?i( ^ ^ G 49 DBA 52@ 4b\ HACK` j,L¬ G\F1 YF 1@ 2F5b\±

Hj-* 12. G'- B+ZD-

45

4?i( n‚ %g n‚ %g 2v 80/ / W 8fF 1>@  j,L¬ 5@b51 `1b\ 4b\ F:b 2F5b\ `1b\ vF ABC*?3

Hj-* 1J. :q- -*

46

4?i( ‚ T\4 ‚ T\4 8r
He2 *. T\4 8r 

K2/ X 1F 12r 5o 3'  1\@ @.

47

4?i( w‚ %g w‚ %g 2v 80/ 49 5F@ 2r1 5F / W HACK` j,L¬ C@b51 F YF `1b\ 4b\ F:b HACK` `1b\ vF ABC*?3

Hj-* 1n. :q- -*

48

4?i( {‚ T>@ {‚ T>@ * 8/by 1] 1] RX DBA‡HACK DBA‡HACK** <2 RfF / / W W 2z: œ 4b\ HACK` j,L¬ 5\bF1b 8/by YF‡2F5* F bRb51 ° …\@: YF‡4b\ ? y2b\ y2b\bb 4b\ 4b\F: F:b™ b™²¯ ²¯2F 2F5 5b\¯ b\¯±±

Hj-* 1. Tƒ< >s

49

4?i( |‚ T>@ |‚ T>@ * @: 5o 1] RX HACK`.DBA‡Uj`j j,L¬ 5\bF1b @: 2F5b\.YF‡4b\ 2F5b\.YF‡4b\ …@\ YF‡2F5b\±

Hj-* 1w. Tƒ< Z-<-ZY

50

4?i( 10‚ %g 10‚ %g 2v R>/ 4b\ j,L¬ 5@b51 `1b\ 4b\ F:b HACK` `1b\ vF ABC*?3

Hj-* 1{. :q- -* ƒ> +

51

4?i( 11‚ T\4 11‚ T\4 8r 1] / W 1\@ DBA‡Uj`  j,L¬ jbRb51 4b\F:b …\@: YF‡4b\±

Hj-* 1|. T+Z - )h- -?a> bc- 

La5 X 1F 12r 5 5o 3"  8X 4b\ HACK` <; Y œ

52

jF4 2/ œ <|5 55 1/J 1\e2 HACK` : <|5 1@X 49 1\@ 2 12m ] 5o 12J ‹b:„ 1>@„ ‹oF„ F ... 55 d R/4 1\@ Yh.T\05 2/ 12[5 2/ ‹oF d R/4„ ]4 5‚4 1>@ * Yh . £ YX/ 12[5 2X2 X /h  1>@ :=1 Yh N2FV/b N2FV/b šMFNV„ šMFNV„ H@Tb„ H@Tb„ P2@„C245V4„ P2@„C245V4„ L4@› 4?i( 12‚ %g 12‚ %g 2v Yz 4b\ j1b: 8X 1>@ Yh N2Q V/] V/] 5\bF1b 1FYRb 2F8/b š :F8 8F\52F\? š^› @1 4RR v\/:F\ b„ 2@1b 8F\52F\? š3t› „ v2@ 8F\52F\? š3t›„ 524584 8F\52F\? š3t›„ R4@ 4:Yb\ ›±

Hj-* 20. :q- -* e„- + &Z)Y  )ƒ< er- N*d- V>hV>h-

53

4?i( 1J‚ T>@ 1J‚ T>@ g: Yh 2/ 52@ Yh N2QV/] /b\1 /1@ 2F8/b 8FR4b š¯8tt*¯„¯:F/ 124¯„¯2F 4¯„¯4F R¯„7tttttt› /b\1 /1@ 2F8/b 8FR4b š¯8tt?¯„¯/: 524b¯„¯2F 4¯„¯124 4¯„¯124 ¯„^tttttt› /b\1 /1@ 2F8/b 8FR4b š¯8tt3¯„¯F 52F2¯„¯/2 @F2¯„¯124 ¯„^tttttt› /b\1 /1@ 2F8/b 8FR4b š¯8tt¯„¯Rb 2@F¯„¯/2 @F2 ¯„ 2F 8/b¯„?tttttt› /b\1 /1@ 2F8/b 8FR4b š¯8tt^¯„¯4@5 1\4¯„¯/2 @F2¯„¯1\4@ v2@ ¯„'tttttt›

Hj-* 21. Tƒ< er- *>

54

4?i( 1^‚ T\4 1^‚ T\4 8r d R/4 1\@ Yh N2Q V/] V/] jbRb51 ° …\@: 2F8/b±

Hj-* 22. T+Z - b >+ )<- er- N*d- V>h-

55

4?i( 1n‚ 1n‚ %g %g 2v Yz 4b\ HF5b\ 8X F 5=1 Rc 5F NVtt* 1f Yh 1\/4 ‹4m 4 1\/4 5@b51 2F5b\lFY5*?3 4vF1b 1b:.2F8/b b1 R4@² 6tttttt y2b\b :F8²¯8tt*¯±

Hj-* 2J. T*Z [> b >+

56

ªjF 525 8n 1\S v2 12X2 2Q 8/] 5o 2Ž 1] RX ,4m5 T\4 T\4 4vF1b 1b:.2F8/b b1 524584²¯2F8/b¯ y2b\b 2@1b²¯4@5 1\4 ¯±

Hj-* 2^. &W (*€( …

57

ª T\4 T\4 8r d R/4 F4 2/ F ²¬ 12F 12F
Hj-* 2n. T+Z - b >+

58

ª T2F
Hj-* 2. T*Z [> (*€( … 4.=.=.7. ThUM C5 @4\5b 5@b 5F vF5Fb — Y 52Z2 F. H‚4 2J1 55 vF5Fb @ O\F5Rb 1>@ \F <94 <|5 y\Fv 8X Yh@ 8 2s Y 52Z2 dF. %Q 522 RX R” 2x :X \@@1/1  n < 2@>1 <=.

59

T2s 12„ 12„ F4 2/ 1>@ :=1 12 1n5 R4 1\d„ 5o 12 1\4 5v :; 4† 12s 4F Yh jOUC` 2 F4 j,L¬j`L`CT 1b‹1 ¤OM Uj`‡jOUC` j,L¬ƒH`` F:b ²¯ƒAPT`jT¯ @\b\ Y R/b± KJ1 4h POC`DU` y\Fv1b1 Ij TkP` b:v‡1FY Ij TABL` TABL` O¤ b:vžOƒTkP` IND`p Bk PLj‡INT`G`± ARR‡b:v b:v‡1FY± B`GIN j`L`CT°BULK COLL`CT INTO FRR‡b:v ¤OM b:v± ¤O / IN *..*t LOOP DBMj‡OUTPUT.PUT DBMj‡OUTPUT.PUT‡LIN`š`:v ‡LIN`š`:v I ®µµ FRR‡b:vš/›.b:v@›± `ND LOP `ND± LX: 12J X@ < 1\2  5 <; v2‚ X@ 2> 52J <|5 1\4 2v 12b@ q :e2. C 1\@ 1\ 1\ 2|v J4 5@b < S F1FYFb F1FYFb o ] <|5 y\Fv 12X2 :=1 2@i5 :=1 v2‚ 5F vF5Fb. ƒ\Fvv/ RX :=1 v2c v2v 12F  \€ 12X2 55 q 1[ :X 52Z O\F5Rb <Ž5 <|5. N2 8„ o 8{ <|5 Y/] 52 8X 12[5 2/ 2 Ye2 12„ :X 8{ 8 { <|5 Yh@ 8 F 1@X. N2 2F5b\ 5o 12 W 55 5s 5n y\Fv 8X 4yFv < F / :; 55 v\@5b4\b„ vF5Fb 80/ 55 v2/] Yh O\F5Rb 2s  n 52b54:. 4.=.=.=. >UM N@ :=1 52c 1\e2 PLlj,L 1\@ O\F5Rb "/„ O\F5Rb R4 5h @4\5b 5@b 8X Y1b 5@b <; 5@:v/Rb 8X@ F1F /51/@F\. P2Q 152 /: 41 8X 1>@ Y1b 5@b RX 2d e /— \F 2/ 1>@ @Y‰b51. K2/ 12[5 12/ :=1 52c 1\e2 PLlj,L /1b\v\b1b\ 1\@ F1FYFb b\8b\ 52Z <Ž5 55 Y1b 5@b 8X 12[5 2/ R2 2d 8 2X2 2r1 <2. %/94 X 1\2 v2h/ v2Q 152„ /: 1\F 5a v2v 8X 55 Y05 25 S 12/ @ 55 Y1b 5@b 52@ /1b\v\b1b\. B1 <‚4 1f O\F5Rb '/ 52a 1F 5o 12 Y/] Y52 55 v\@5b4\b PLlj,L F :; : 1\] F1FYFb b\8b\. O\F5Rb 12s Y@ \z  n v\@5b4\b <|5 Y/] 52 F s d 4] 12 “ /av /h: 12/ /F RX: 8/5 80/ PLlj,L 10/ *t R‚. K2/ 1>@ :=1 52c 1\e2 PLlj,L 5o F1/8b 5@:v/RF1/@„ O\F5Rb “ R4 @4\5b 5@b 1\@ F1F /51/@F\ 8X 12[5 2/ 8/5 v2Q 152 8X /: 41 2 Ye2 12 2/ 1>@ @Y‰b51. NJ4 5@b 2|v R„ 5@b “ 1>@ :=1 …/Rb 4† C 8X Ž/ 1\e2 Y/] 52 8X R/b /b\\ C < 1>@ …/R …/Rb 12 12 8/ 8/ 52/ 52/F Œ 52@ 52@ 52c 52c  1\e2 \e2 PLl PLlj,L j,L
…/Rb 5F Oj. K 1f *t„ 55 …/Rb .Rl .R/Y <|5 R4 1\@ F1FYFb. N2 2 8 5 <; < < 12[5 2/ :=1 m 12F@ 15 2r1 <2. K2 — X  n PLlj,L F1/8b < 12[5 12/ 55 R2 Oj 12s 4F R2 ®FR1b\ 1b:¯. V n AR1b\ 1b: b1 vRR‡F1/8b‡:Fb‡41/R/1²¯5FR5.b‹b¯± AR1b\ 1b: b1 PRR‡F1/8b‡:Fb‡…/Rb‡F:b²¯5¶1b:v¶::Fb…/Rb.:¯± AR1b\ 1b: b1 vRR‡F1/8b‡R/Y\F\‡/\²¯5¶1b:v¶vRR‡R vRR‡F1/8b‡R/Y\F\‡/\²¯5¶1b:v¶vRR‡R/Y¯± /Y¯± jF4 :”/ R‚ Y/] 52 :; PLlj,L„ O\F5Rb Y1 <‚4 1\e2 Y/] 52 PLlj,L„ 15 RX Ž/ 10/ 1/ 52 5FR54RF1@\ 5F ƒ/@y ƒ/@y V n„ 52a 1F 5o 12 5X/
Hj-* 2w. &W b…- L/&SL jF4 / R‚ dF. 12F 12J 55 …/Rb :0/ Y/] /52 Yz v2/] Yh YF5@@\ 1\05 / <|5 52>.

Hj-* 2{. &W b…- L/&SL 61

2.^.n. MF )r )- (F- O( W b…- R<<)=>) =X) *† i> 4(=b<< % Rr d R/4 1f F1FYFb„ 552 125 v2W 2|v 2r1 RX J1 2|v \@@1/1 F1FYFb 8X YF5@@\ F1FYFb. BF5@@\ 52@ v2•v F11F5b\ 12[5 2/ 5Q4 R2 8X 1\4 8r F1FYFb 1f ‹F 8X 2 2†/ <v 1f b\8b\. A11F5b\ \€ \X 2s :4m 55 2X2 8/ 5F :e2 Y DBA v21 2/„ 8e 8 F11F5b\ 12 J1 2|v 5X/ YF5@@\ 80/ \@@1/1 < 52b /r4 2@>1 <= 5F YF5@@\. £ @ :=1 52c 1\e2 YF5@@\„  n :=1 525 g b1y@\ 5o  < :S :=1 J1 m/ 10/ 8 1\ 5F F11Fb\. C2c 1\e2 “ <Ž5 J1 m/ 8X 12[5 2/ 55 5Q4 R2 F11F5b\ / 10/. jF4 / J1 4h 12[5 2/ 5F 5Q4 R2. C2c 1\e2 YF5@@\ 5o 12 <|5 Rv R52„  n 525 g ‰@Y < J4 J1 m/ Y :r1 2@i5 F1FYFb /1F5b Y \b1F\1 12e F11F5b\ 8{ 5o 12 J1 m/ 1>/ 12/  1\] 2@1 5F F11F5b\ “ /F@ 1/Jv 4F /F@ 125 TCPlIP. TCPlIP. BF5@@\ 5@@Rb R 2b 1\] :=1 TCP v@\1 ‹5 <2 1\05„ <|/ J1 m/ 1f YF5@@\ C2a 1F “ 1>@ :=1 55 \@@1/1 8X YF5@@\ Yz :; PLlj,L. 4.=.Q.. T3( E((t6it FE@ :=1 …451/@ < 52Z2 F F1F /51/@F\ 8/by DYF‡‰@Y„ YF‡‰@Y‡\4/. K4Š‡‰@Y‡8/by < 52b /r4 YF5@@\ ‰@Y. ¤451/@ X 5o 12 <|5 /‰b51 8X@ Yr1 ¡ R” 2x j,L /‰b51/@ X@.

62

C@b œ 5@b51/@ /dF YF5@@\ 8X YF5@@\ 5@@Rb CÀT` O `PLAC` ¤UNCTION ION /‡\@@ \@@1/1 /1 `TU `TUN VACH CHA? CU`NT‡Uj` Aj PAGMA AUTONOMOUj‡TANjACTION± B`GIN

AUTHID

C@b œ 5@b51/@ /dF YF5@@\ 8X YF5@@\ 5@@Rb 1\@ .YF‡‰@Y `p`CUT` IMM`DIAT` ®CÀT` O `PLAC` ¤OC` VI`ƒ Ÿjkj.DBA‡ÔBj šŸÔB„ ŸLOG‡Uj`„PIV‡Uj`„jCH`MA‡Uj`„LAjT‡DA ŸLOG‡Uj`„PIV‡Uj`„jCH`M A‡Uj`„LAjT‡DAT T`„LAjT‡j` C„THIj‡DAT`„ ŸTHIj‡j`C„N`pT‡DAT`„N`pT‡j`C„TOTAL‡TIM`„ ŸBOK`N„INT`VAL„ Ÿ¤AILU`j„ƒHAT„NLj‡`NV„MIjC‡`NV„INjTANC`› Aj jbRb51 ÔB„ R@yb\LOG‡Uj`„ v@yb\ PIV‡Uj`„ 5@yb\ jH`MA‡Uj`„ LAjT‡DAT LAjT‡DAT`„ 4Y1\š1@‡52F\šRF1‡F1b„HH?MIjj›*„"› LAjT‡j`C„ THIj‡DAT THIj‡DAT`„4Y1\š1@‡52F\š12/‡F1b„HH?MIjj›„*„"›THIj‡j`C„‰ `„4Y1\š1@‡52F\š12/‡F1b„HH?MIjj›„*„"›THIj‡j`C„‰.…b/R* .…b/R* INjTANC` ¤\@: .‰@YŠ ‰„ 8ŠR@5 8 ƒ2b\b 8.1vb ² Ÿˆ, F ‰.‰@Yšª›² 8./? F ‰.y2F1 @1 R/b ŸD`CLA` *‡5 UTL‡TCP.CONN`CTION±ž¯± C@b œ 5@b51 /dF YF5@@\ 8X YF5@@\ 5@@Rb 1\@ .4Š‡‰@Y‡1 `p`CUT` IMM`DIAT` ®CÀT` O `PLAC` ¤OC` VI`ƒ Ÿjkj.KUŠ‡ÔB‡VI`ƒ O¤ Ÿjkj.KUŠ‡ÔB‡T ƒITH OBˆ`CT ID`NTI¤I` šv@yb\‡/› Aj bRb51 Ÿ*„t„ 4.4b\³„ ‰.v@yb\„ ‰.R@yb\„ ‰.5@yb\„ ‰.‰@Y„ TO‡CHAš‰.RF1‡F1b„kkkkwMMwDDHH?MIjj›„ TO‡CHAš‰.12/‡F1b„kkkkwMMwDDHH?MIjj›„ TO‡CHAš‰.b‹1‡F1b„kkkkwMMwDDH?MIjj›„ ‰.…RF„ ‰.…F/R4\b„ `PLAC`š‰./1b\8FR³„¯„›„ `PLAC`š‰.y2F1„„›„ `PLAC`š‰.Rb8„„›„ ‰.b8„ ‰.…/bR*„ ‰.52F\b8 …\@: .‰@YŠ ‰„ .4b\Š 4 y2b\b ‰.v@yb\²4.F:b F ‰.y2F1 @1 R/Rb ŸD`CLA` *‡5 UTL‡TCP.CONN`CTION±ž¯± COMMIT± `TUN± `ND± 63

4.=.Q.4. T3( FE@ :=1 …451/@ 12[5 2/ ‰@Y <Ž5 5@::F 1f 2@1 5F F11F5b\„ F11F5b\„ 12[5 12/ 52a 8X / 5@::F 5@ ::F @41v41 1\S 89 52@ F11F5b\. T>@ :=1 …451/@ /‡YF5@@\ 12[5 12/ 80/ 49 5F 4b\ Ž/ o„ …451/@ 5o  pML± j`L`CT DBID„NAM` INTO *‡5@R51„*‡R1: ¤OM VŠDATABAj`± j`L.`CT YFb\ INTO *‡5@R51„*‡5@R4:8FR4b ¤OM VŠV`jION ƒH`` OƒNUM²*± *‡\b1 \b1‡8FR²UTL‡TCP.ƒIT` IT`‡LIN`š*‡ š*‡5„ Ÿ«´‹: ´‹:R 8b\/ \/@²*.t b5@/²41…w" ´¬«R5@::/C@ ‹:R²211v±ll1b:v4\F.@\lI5@:/BF5@@\C@.‹ 64

DBT DBTvb² vb²O\ O\F5 F5Rb Rb b\8b b\8b\V \Vbb\/@ \/@² ²µ µµµ *‡5@R *‡5@R4: 4:8 8FR FR4b 4b µµ Ÿ¯DB Ÿ¯DBNF NF:b :b² ² µµ *‡R1: µµ DBID² µµ *‡5@R51µµl.¬›± LOOP *‡R1: ²UTL‡TCP.G`T‡LIN`š*‡5„ TU`›± `pIT ƒH`N UPP`š*‡R1:›²`pIT± B`GIN *‡12b54\@\²DBMj‡j,L.OP`N‡CUjO± NJ4 5Q4 R2 j,L 2 <|5 RX jbRb51„<‚4 1/] o “ Rr 1r1 5h 1] 5=1 8X / 52a 89 < YF5@@\ 5@@Rb 2/ 12 55 5@R4: 2bFb\ X 1v 1\4. I¤šjUBjTšLT I¤šjUBjTšLTIMš*‡R1:››„ *„ 7››²j`L`CTTH`N DBMj‡j,L.PAj`š*‡12b54\@\„*‡R1:„DBMj‡j,L.NATIV`›± DBMj‡j,L.D`jCIB`‡COLUMNjš*‡12b54\@\„*‡5@R51„*‡bb‡1›± ¤O I IN * .. *‡5@R51 LOOP *‡\b1‡8FR² UTL‡TCP.ƒIT`‡LIN`š*‡5„ UTL‡TCP.ƒIT`‡LIN`š*‡5„ µµ *‡b5‡1š/›.5@R‡F:b›± DBMj‡j,L.D`¤IN`‡COLUMNš*‡12b54\@\„ DBMj‡j,L.D`¤IN`‡COLU MNš*‡12b54\@\„ I„*‡5@R4:8FR4b„?ttt›±

65

CHPQNG J. H"T HIỆN VÀ H‡NG TR"NH ROOTKIT 7.. >hưZng Yh9Y Yh9t hiện E((t6it Co 2F/ 552 522 < v21 2/ :=1 \@@1/1 1\] : Y 2/—: 4•1 8X 12b@ €/ 55 [ /. J.1.1. S+ˆ) P2c v2v v21 2/ \@@1/1 o/ 524 12 RX @ 2 2F/ 1\> 12/ 1\05 8X F4 5F 2 12m < 1e: \F / 80/ :=1 2 12m >52 ª j@ 2 F2 52 55 1v 2/ 5o 80/ NT¤j MF1b\ ¤/Rb TFYRb ª j@ 2 55 2oF \b/1\ 80/ :=1 :{4 >52 ª j@ 2 F2 52 1/J 1\e2 8X 52 8n  n 2/94 2X: 2 12m 25 2F4. ª j@ 2 F2 52 1/J 1\e2 8X 52 8n Yz  1241 52¢ 1/J 1\e2 5F \@@1/1. ª P21 2/ 8/5  n ADj ª j@ 2 55 1\> 12/ 5F Yh 52 8n 2 12m. ª K/: 1\F 55 v2‚ 1 1\@ Yh Ž/ 52 8n 2 12m 5o z: 1\@ h/ <F 52Z 5F 55 :@4Rb R/] 4F 2F 2s. ªDW 1e: 12b@ 52d  5F \@@1/1 1\@ 8W 20 5F 2Q. KE 1241 4•1  n v2c v2v @ 2 552 2e 5F 2 12m  n 55 5s 5n :5 / W 80/ 552 2e 1f Y] 1\@ R€/ H%H. NJ4 5o r4 2/4 52b /r4 X@„ 12X2 v2‚ 1 J1 4h 522 ‹5. Hc dF„ \@@1/1 5o 12 1\2 Y v21 2/ Yz 552 52b /r4 1r1 5h 55 1/J 1\e2 @>/ 1\f 522 1/J 1\e2 v21 2/ \@@1/1. \@@ 1/1.

66

J.1.2. T*< b‰> ('( g =>M=1 552 25 RX  n :=1 2 12m 2@>1 <= [F 1\] 55 [ / R/] 1n5 12b@ €/ < 5o 12 : <|5 \@@1/1 8X@ 12/ v 55 :@4Rb 5F H%H. T4 T4 2/] 8/5 2oF 2J1 55 :@4Rb R>/ RX :=1 v :=1 :@4Rb 5o v2h/ RX ‹r4 2F 2s Yz 552 ‹b: ‹•1 55 124=5 12 25 5F Y= 5X/ / 2@X 1@X 2s /m 2F4. V n„ :=1 \@@1/1 5o 12 5m  ŸR2 :i1 Yz 552 2s 1>@ \F 5F x 1\[5 4F„ 1\@ 2/ :=1 1\e2 /1 8/\4 R>/ :4m 52@ / W Y/J1 [ 2/ / 5F 52c 1\e2. T\e2 \@@1/1 5 5o 12 5X/ :=1 bR@b\ šY1 YX v2: 8X / 12s 1/ 10/ :=1 / W 25› 5 :=1 52c 1\e2 /1 8/\4 12e 2@X 1@X 2s RX: 12J. Bz 552 1x 2|v 55
w w w w w w

7.4. >hng tE9nh 5((t6it % v2 52m \@@1/1 RX g 52i 2h g 5X/  :> 8X 2@1w 2@1w YFb. YFb. Cv Cv 21 21 55 55 Yh Yh 8 8 52@ 52@ 2  :>22 K2s K2s YF@ YF@ / /  n v2‚ v2‚ :9: 1f 2d 2d 4† 4† 2s 2s 1/ 1/ 5 5 Tr1 5h 55 \@@1/1 1\4 5v 2 12m <52 5o 49 /m 2 4h 1\ 8/]„ @ / 2
< 1/ 5. C5 C5 4h 1\ 8/] 5 ] /d  :=1 4† < 1/ 5 < 5X/  ‹5 :/2„ 52@ v2•v 1\4 5v 8X 5X/ / :Ž/ v2: 11. KbR@b\ v2‚ :9: 5o 12 v2 2@>/ 2 12m 2 T\@‰F 2@i5 8/\4b. KbR@b\ RX v2‚ :9: / / 1\@ 4Y / Y‘ \@@1/1 2 2/4 4h. PFF A1/w@@1/1 5o 4 R| 2‘„ 2s 5‚ 5X/  v2h/ / ybY/1b 5F PFF 1\05 2/ 1h/ ‹4m. 68

C2c 1\e2 12 2F/ ]  n RX BRF5L/21. PFF A1/w@@1/1 8X BRF5L/21 5o 2h g v21 2/ 2‚4 2J1 55 \@@1/1 :X 55 52c 1\e2 52m 8/\4 Y‘ 4F. T4 2/] 5h 2F/ <94 2s v2h/ RX 52c 1\e2 12[5 [ 2@X 2h@ ] 1m1 2r1 RX ] W 5h 2F/ 52c 1\e2. NJ4 RX /  n : 12 5o /2 2/: ] 12 W @@1/1b8bFRb\ 5F jI1b\FR. P2‚ :9: X 5o 4 R| ?3*KB„ RX Yh 2F\byF\b šW 524›„ 52> 1\] 1r1 5h 55 v2/] Yh ƒ/@y. C2c 1\e2 X  n E 1241 25 2@X 1@X 80/ PFF A1/w@@1/1 8X BRF5L/21„ 8e 12J Y> ]  n 5h YF 52c 1\e2 < 5o g R[5 1m/ 2 :“ 2r1 1\@ 54=5 52/J v21 2/ \@@1/1 RX 55 h v2œ: 5o 4† m5 T\4 ,4m5 I5bjy@\ 8X DF\jv. C5 52c 1\e2 X 5o 5s 5n /av ¥
69

K$T LUẬN . '9nh gi9 6%t auả 13t 1ưfc. 1.1.VD =X) B+r )jY *>\+ Š )*+ZX). w Te: 2/4 89 \@@1/1„ v2Q R@>/ \@@1/1„ 552 125 2@>1 <= \@@1/1. j[ 25 2F4 /dF \@@1/1 80/ 8/\4. w Te: 2/4 <|5 1x 4F 89 2 4h 1\ 5c S d R/4 O\F5Rb 5r4 1\a5 5F 55 O\F5Rb /1F5b 8X O\F5Rb DF1FYFb. C52 125 1r 5s 5F @@1/1 8X@ 2 5c S d R/4 O\F5Rb. wTe: 2/4 <|5 552 v2 52m @@1/1 . 1.2. VD =X) B+r (> [t)  )- (F- . w %; 5X/ @ \F :=1 4b\ HF5b\ 5o vF y@\ FY5*?3 „ <|5  49 YF 8X 12[5 2/ 1>@ \F :=1 8/by 8X @: < œ 4b\ HF5b\ 1\@ 2/ /5F 4b\ HF5b\ 8X : <|5 49 5F@ 2r1 5F 2 12m. K2/ : <|5 49 5F@ 2r1„ 4b\ HF5b\ 12[5 2/ 55 12F@ 15 12]:„ F „ ‹oF.. :=1 Yh 2Q 8/] < 12F
70

TÀI LIỆU THAM KH5O ·*¸. %†  1m1 2/v ?t*t„ ®Tr 5s @@1/1 1\@ O\F5Rb¯ ·?¸. Tj. N4— NF: Hh/„ ŸG/@ 1\e2 A 1@X 5c S d R/4„ HŽ5 8/  1241 :1 :;„ ?tt6 ·3¸. 211vllF1 211vllF1@F12@ @F12@1/ 1/.8lD .8lDb1F/R b1F/R.Fv‹ .Fv‹ĆF1ID² ĆF1ID²Yb^77" Yb^77"?twb67 ?twb67YwF56w YwF56w'^F'w '^F'w Y?5*5"7FF^…¹NbyID²*Y^bw"*t3wtw'56bwtt53……bt?Y ·¸. b F1FYFb b\54\/1 ·^¸. HF5‡O\F5Rb‡ jb\54\/1 ·6¸. 211vll@5.@\F5Rb.5@:l5lB?"3^'‡t*l/ 211vll@5.@\F5Rb.5@:l5lB?"3^'‡t*l/b‹.21: b‹.21:

71

Oracle Rootkit

Recommend Documents