ࡱ> ^`]gEbjbj***NHibHib 4<2jtLD$1111111$461Ett1.2F^^^1^1^^6/)10zj01t2<20dT8jT88)1)1&T8O1`^11^2T8 m G:   -"%'! ! >43>B>2:0 8 A1>@ 40==KE (" !) #!"  #!" !   '!" =0 ?;0BD>@<5 MS SQL Server 8AB>2 6 2017 !   TOC \o "1-3" !   PAGEREF _Toc95908228 \h 2 1. 1I85 ?>;>65=8O  PAGEREF _Toc95908229 \h 3 2. "@51>20=8O : 1075 40==KE ()  PAGEREF _Toc95908230 \h 3 3. #AB0=>2:0 A5@25@=>9 G0AB8 " !  PAGEREF _Toc95908231 \h 3 4. !>740=85 =>2>3> ?>;L7>20B5;O " !  PAGEREF _Toc95908232 \h 4 5. #AB0=>2:0 :;85=BA:>9 G0AB8 " !  PAGEREF _Toc95908233 \h 5 6. !! !,+% !"'  PAGEREF _Toc95908234 \h 6  1. 1I85 ?>;>65=8O  :0G5AB25 A5@25@0 107 40==KE () 8A?>;L7C5BAO A8AB5<0 C?@02;5=8O 1070<8 40==KE (!#) Microsoft SQL Server 2000 8;8 2KH5. 2. "@51>20=8O : 1075 40==KE () @0B:85 @5:><5=40F88. =AB0;;OF8O >1J5:B>2 107K 40==KE () " ! ?@>872>48BAO =0 107C !# Microsoft SQL Server 2000 8;8 2KH5. 5@54 =0G0;>< CAB0=>2:8 A5@25@=>9 G0AB8 " ! =5>1E>48<> A>740BL 107C 40==KE ELODB. ;O :@548B=>9 >@30=870F88 () @5:><5=4C5<K9 =0G0;L=K9 @07<5@ D09;0 40==KE ELODB: 150 Mb 0G0;L=K9 @07<5@ D09;0 6C@=0;0 B@0=70:F89 Transaction Log: 20Mb 3. #AB0=>2:0 A5@25@=>9 G0AB8 " ! #AB0=>2:0 A5@25@=>9 G0AB8 " ! ?@>872>48BAO 04<8=8AB@0B>@>< SQL Server, 8<5NI8< ?@020 4>ABC?0 SA (System administrator). #AB0=>2:0 A5@25@=>9 G0AB8 ?@>872>48BAO ?CB5< 8A?>;=5=8O A:@8?B0 ko_create_ptk.sql 2 @01>G5< >:=5 8A?>;=5=8O 70?@>A>2 CB8;8BK Query Analyzer, 2E>4OI59 2 :><?;5:B ?>AB02:8 48AB@81CB820 Microsoft SQL Server 2000. >A;5 8=AB0;;OF88 A5@25@=>9 G0AB8 " ! 1C4CB A>740=K CG5B=K5 70?8A8 (logins) 8 A>>B25BAB2CNI85 8< ?>;L7>20B5;8  (users): ADMINSYS A ?0@>;5< ADMINSYS  04<8=8AB@0B>@ " !; ADMININF A ?0@>;5< ADMININF - 04<8=8AB@0B>@ 8=D>@<0F8>==>9 157>?0A=>AB8 " !; ! >A;5 8=AB0;;OF88 2A5 ?0@>;8 ?>;L7>20B5;59 " !, A>740205<K5 ?> C<>;G0=8N, =5>1E>48<> 87<5=8BL! "0:65 2 ?@>F5AA5 8=AB0;;OF88 A>7405BAO ?>;L7>20B5;LA:0O @>;L ptk_user_role. ';5=0<8 MB>9 @>;8 1C4CB O2;OBLAO 2A5 ?>;L7>20B5;8 " ! 70 8A:;NG5=85< 04<8=8AB@0B>@>2 ADMINSYS 8 ADMININF. !>740==K5 ?>;L7>20B5;8 8 @>;L 1C4CB 8<5BL ?@020 =0 @01>BC A B01;8F0<8 " !.  1075 40==KE MS SQL Server 2000 ?>A;5 8=AB0;;OF88 1C4CB A>740=K @01>G85 B01;8FK " !: ELO_ARH_POST, ELO_BNK, ELO_FIN_DATAL, ELO_FIN_DATAM, ELO_FRM_STATUS, ELO_MAIL_CFG, ELO_MAIN_REPORT, ELO_MODIFY, ELO_OKUD, ELO_PATH, ELO_SPR_BIK, ELO_SPR_ERR, ELO_SPR_POST, ELO_SPR_POST_SUB, ELO_SPR_STATE, ELO_STRUCT_ROOT, ELO_TABLES, ELO_TYPE_DOC, ELO_USER_JOB, ELO_USERS, ELO_USERS_ACCESS, ELO_USR_ERR, ELO_USR_PROTOCOL, LDV_ADD_INFO, LDV_FIN_APPL, LDV_FIN_COLUMN, LDV_FIN_CONSTL, LDV_FIN_DATAL, LDV_FIN_HEADER, LDV_FIN_STRING, LDV_LOGCTRL_CODE, LDV_LOGCTRL_DATA, SVSPR_APR, LDV_FIN_REFR. 4.   " ( * 6 8 Z ~     4 6 h j l n p r o j{h!UmHnHu-h;2h!5;CJOJQJaJmHnHu jh!UmHnHujh!UmHnHuh!mHnHujh?Uh 3h?5CJmH sH h 35CJmH sH  h?5CJh?;mH sH  h?; h!h h?%   : < > @ B D F H J gd! $$ & Fa$J L N P R T V X Z l n p r t v x z  r z     $a$ X$a$ < > p r t v x z      T V        Z ذ؟؎}soh?jh?CJU jh!UmHnHu jgh!UmHnHu jh!UmHnHu jqh!UmHnHu-h;2h!5;CJOJQJaJmHnHuh!mHnHujh!UmHnHu jh!UmHnHu) " $ & ( * , . 0 2 4 Z \ TVXRTV$a$7`7$7`7a$$$a$$a$Z  &(4>@PX"ZlntvDNR\rtz \bdpX\FXZ`bn hݿh?B*CJhmH phsH h?B*CJhphh?mH sH h! h!CJh? h 3CJh 3h 3CJh?CJmH sH  h?CJEx^r&BTr.Hb7`7 $ & F ha$$a$$7`7a$hrr^Zh^l"&0:0H0L0N000001 111161v111111222222F4`4f4h444444444444ùùùh<CJmH sH  h<CJUh?mH sH h! h?;h? h!5 h?5 h!CJ h?CJh?CJmH sH Db~ $6CUcqJ0L0<1F44$7`7a$$a$7`7!>740=85 =>2>3> ?>;L7>20B5;O " ! C>740=85 =>2>3> ?>;L7>20B5;O ?@>872>48BAO 04<8=8AB@0B>@>< SQL Server, 8<5NI8< ?@020 4>ABC?0 SA (System administrator). !>740=85 =>2>3> ?>;L7>20B5;O " ! ?@>872>48BAO ?CB5< 8A?>;=5=8O A:@8?B0 ko_create_user.sql 2 @01>G5< >:=5 8A?>;=5=8O 70?@>A>2 CB8;8BK Query Analyzer, 2E>4OI59 2 :><?;5:B ?>AB02:8 48AB@81CB820 Microsoft SQL Server 2000. <O 8 ?0@>;L A>740205<>3> ?>;L7>20B5;O C:07K20NBAO 04<8=8AB@0B>@>< 2 ?@>F5AA5 53> A>740=8O ?CB5< C:070=8O 8<5=8 A>740205<>3> ?>;L7>20B5;O 2 B5:AB5 A:@8?B0 2 AB@>:5 set @newusr='8<O_A>740205<>3>_?>;L7>20B5;O'. !>740=85 =>2>3> ?>;L7>20B5;O " ! A ?@020<8 04<8=8AB@0B>@>2 A8AB5<K ?@>872>48BAO ?CB5< 8A?>;=5=8O A:@8?B>2 ko_create_admin.sql 8 ko_create_aib.sql (ko_create_admin2008.sql 8 ko_create_aib2008.sql 4;O SQL Server 2008) 2 @01>G5< >:=5 8A?>;=5=8O 70?@>A>2 CB8;8BK Query Analyzer, 2E>4OI59 2 :><?;5:B ?>AB02:8 48AB@81CB820 Microsoft SQL Server 2000 8;8 2 A@545 Microsoft Management Studio. <O 8 ?0@>;L A>740205<>3> ?>;L7>20B5;O C:07K20NBAO 04<8=8AB@0B>@>< 2 ?@>F5AA5 53> A>740=8O ?CB5< C:070=8O 8<5=8 A>740205<>3> ?>;L7>20B5;O 2 B5:AB5 A:@8?B0 2 AB@>:5 set @newusr='8<O_A>740205<>3>_?>;L7>20B5;O'. >A;5 >B@01>B:8 A:@8?B0 1C45B A>740=0 CG5B=0O 70?8AL 8 A>>B25BAB2CNI89 59 =>2K9 ?>;L7>20B5;L , 8<5NI89 ?@828;5388 =0 @01>BC A @01>G8<8 B01;8F0<8 " !. 0@>;L CG5B=>9 70?8A8 ?> C<>;G0=8N A>2?0405B A 55 8<5=5<. 0;55 A;54C5B A>740BL ?>;L7>20B5;O " ! A MB8<8 CG5B=K<8 40==K<8 HB0B=K<8 A@54AB20<8 <>4C;O 4<8=8AB@0B>@ " ! [1]. K40G0 >1J5:B=KE ?@828;5389 " ! (@01>B0 A <>4C;O<8, D>@<0<8) ?@>872>48BAO HB0B=K<8 A@54AB20<8 <>4C;O 4<8=8AB@0B>@ " ! [1]. #AB0=>2:0 :;85=BA:>9 G0AB8 " ! #AB0=>2:0 :;85=BA:>9 G0AB8 ?@>872>48BAO 2 A;54CNI59 ?>A;54>20B5;L=>AB8: @>8725AB8 CAB0=>2:C A5@25@=>9 G0AB8 2 A>>B25BAB288 A 40==K< 4>:C<5=B><; @>8725AB8 HB0B=CN CAB0=>2:C " ! 2 A>>B25BAB288 A [1]; !@54AB20<8 <>4C;O 4<8=8AB@0B>@ " ! 2K?>;=8BL A>740=85 @575@2=>9 :>?88  (>?5@0F8O K3@C78BL ?> 2A5< B01;8F0<). #40;8BL 87 ?>;CG5==>3> B5:AB>2>3> D09;0 A5:F8N, A>>B25BAB2CNICN B01;8F5 ELO_USERS; @>8725AB8 =0AB@>9:C dsn ODBC =0  Microsoft SQL Server 8 ?@>8725AB8 ?5@5?>4:;NG5=85 <>4C;O 4<8=8AB@0B>@ " !. E>4 >ACI5AB2;O5BAO ?>4 8<5=0<8 ADMINSYS 8 ADMININF; K?>;=8BL 703@C7:C @575@2=>9 :>?88  (>?5@0F8O 03@C78BL); 0;L=59H0O @01>B0 A !# Microsoft SQL Server >ACI5AB2;O5BAO 2 A>>B25BAB288 A >1I8<8 4>:C<5=B0<8 70 8A:;NG5=85< ?@>F54C@K A>740=8O =>2>3> ?>;L7>20B5;O. 6. !! !,+% !"' 1. 2B><0B878@>20==0O A8AB5<0 >43>B>2:0 8 A1>@ 40==KE " !. =AB@C:F8O ?> CAB0=>2:5 ?@>3@0<<=>3> >15A?5G5=8O. - "C;0: B45;5=85 ?> "C;LA:>9 >1;0AB8 ;02=>3> C?@02;5=8O ?> &5=B@0;L=><C D545@0;L=><C >:@C3C, 2015. 4444444455,5.5F5H5R5T5h5j5z5|555555555666.646X6Z6\6j6l6t6v666666666666677 7V7\7^7`7b7l7789990929J9R9T9z:::;¼ h?CJh?CJmH sH hL4CJmH sH  h<CJh<CJmH sH  h!CJ%hCh!CJ'*mH sH J48P9R9T9;;==L=N==r>>@ARBTBCCCCC$$a$7`7 & F  $ & F a$gd}|$7`7a$ $7`7a$gd<;F;T;;;;;0<><<<=<=J=N=>>*?8?j@p@r@|@@@@@@@@@@@XAfAAAAABBBBBBCCCCFDTDXDDDD2E4EzEEEEEȿ hI~aJhI~hI~aJhI~h?aJ hI~h?hI~h?CJmH sH h!h? h?CJh*]h*]CJ h!CJ h*]CJ=CEE7`7`gdI~(. A!"#$% {DyK  _Toc95908228{DyK  _Toc95908229{DyK  _Toc95908230{DyK  _Toc95908231{DyK  _Toc95908232{DyK  _Toc95908233{DyK  _Toc95908234s666666666vvvvvvvvv666666>666666666666666666666666666666666666666666666666hH6666666666666666666666666666666666666666666666666666666666666666662 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@_HmHnHsHtH:`: 1KG=K9_HmHsHtHT@T  03>;>2>: 1$<@&5CJKHOJQJ``  03>;>2>: 2"$&<#$8/.@&56OJQJV@V  03>;>2>: 3$$ & F,x@&a$5CJNN  03>;>2>: 4 $1$@&CJhmH sH uBA B A=>2=>9 H@8DB 0170F0\i\ 01KG=0O B01;8F0 :V 44 la .k . 0 5B A?8A:0 `C@` A=>2=>9 B5:AB A >BABC?><$7`7a$CJN@N p 3;02;5=85 1xx  5;CJ@@  3;02;5=85 2 ^:@@  3;02;5=85 3 ^6@@  3;02;5=85 4 X^XCJ@@  3;02;5=85 5  ^ CJ@@  3;02;5=85 6 ^CJ@@  3;02;5=85 7 ^CJ@@  3;02;5=85 8 x^xCJ@@  3;02;5=85 9 @^@CJBB@B A=>2=>9 B5:AB$a$CJ^^ NameDoc#$$$ dh *$a$5;CJ OJQJX`X I~ 57 8=B5@20;0$S`Sa$CJ_HmHsHtHJJ X70 "5:AB 2K=>A:8CJOJQJ^JaJP/P X70"5:AB 2K=>A:8 =0:CJOJQJ^JaJPK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭V{+N8aq-*GlLi˽6Lj3~pmGo 1*?f8&,ɴ8N>hR*Պ"(zsy2!#YQ$\h2軧>:HC A84Bq.UJR_O]-4k!ᣄD=zvg?s6re؝GT{<˷/|N:OWB_?>xo'hGIs ;WY ;ɛY CDtv<(Fr Ȃ`3Ax&sA,/fvXb9<'O:*B{Yg2A E@Sc.Ɩ Ĉ6%pn5$CcT< / AȷNQ۪xD½S#\r""`t\ SƘs֫%Ȍ=tD]ϋ1eA ; qc?Pȹ„ ;D~ $N Z h4;E#%J  b4CE$&57Zuw*EGm %%%%%%%ĕ8@0(  B S  ? _Toc480711580 _Toc95908228 _Toc95908229 _Toc95908230 _Toc95908231 _Toc95908232 _Toc95908233 _Toc95908234, FL$ ' . ' , - 5 ( . p q UX'2Bj t # & &5{~Qg33333333IXI $ & + :2B'",P0/)WT2"$wlE&I\+G+ IyМ8Th)XW} ahi$[r<0>^`o( ^`hH. pL^p`LhH. @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PL^P`LhH.^`o(-88^8`o(-^`o(-^`.hh^h`.5P^`P..5^`...5x^`x.... ^` .....  X ^ `X ......   ^ `....... 8^`8........ `^``.........hh^h`o(.\^`\o(..0^`0o(...0^`0o(.... 88^8`o( ..... 88^8`o( ...... `^``o(....... `^``o(........ ^`o(.........h^`.h^`.h L ^ `L.hw w ^w `.hGG^G`.hL^`L.h^`.h^`.hL^`L.88^8`o(-^`o(. ^`hH. pL^p`LhH. @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PL^P`LhH.P^`P.^`..g^`g...``^``... ^` .... ^` ..... ^` ...... `^``....... 00^0`........ '"[rX0/)+ IT2+GlE8T:2} a ַJ(<9X%qC }|;2 3L4PI~"4<Eg/X7C!>o*]?@@     8@ 0Unknown@;>20 !25B;0=0 .@L52=0G.[x Times New Roman5Symbol3. .[x Arial7..{$ Calibri9.. Segoe UIA$BCambria Math"1h''? '? '20KqHX  $Pp <2!xx 5@54 =0G0;>< CAB0=>2:8 A5@25@=>9 G0AB8 " ! 2 ACI5AB2CNICN 107C 40==KE =5>1E>48<> A>740BL 2 =59 420 B01;8G=KE ?@>AB@0=AB20 PTK_DATA 8 PTK_INDEXRVA@;>20 !25B;0=0 .@L52=08         Oh+'0,8DP`     PTK_DATA PTK_INDEXRVANormal 2Microsoft Office Word@F#@Nm@Nm? ՜.+,0 hp  d '   PTK_DATA PTK_INDEX    !"#$%&')*+,-./123456789:;<=>?@ABCDEFGHIJKLNOPQRSTVWXYZ[\_Root Entry FszaData (1Table08WordDocument*NSummaryInformation(MDocumentSummaryInformation8UCompObjr  F Microsoft Word 97-2003 MSWordDocWord.Document.89q