CARVIEW

MOTORHOMES

Select Language

HTTP/2 301 date: Tue, 07 Oct 2025 01:56:34 GMT content-type: text/html content-length: 162 location: https://atmarkit.itmedia.co.jp/fsecurity/rensai/dbsec04/dbsec01.html server: nginx strict-transport-security: max-age=31536000 HTTP/2 301 date: Tue, 07 Oct 2025 01:56:34 GMT content-type: text/html; charset=iso-8859-1 content-length: 271 location: https://atmarkit.itmedia.co.jp/ait/articles/0312/05/news002.html server: nginx x-frame-options: SAMEORIGIN strict-transport-security: max-age=31536000 HTTP/1.1 301 Moved Permanently Date: Tue, 07 Oct 2025 01:56:34 GMT Content-Type: text/html Content-Length: 162 Connection: keep-alive Server: nginx Location: https://atmarkit.itmedia.co.jp/ait/articles/0312/05/news002.html X-Frame-Options: SAMEORIGIN Strict-Transport-Security: max-age=31536000 HTTP/2 200 date: Tue, 07 Oct 2025 01:56:34 GMT content-type: text/html server: nginx vary: Accept-Encoding x-frame-options: SAMEORIGIN strict-transport-security: max-age=31536000 content-encoding: gzip Oracle?f?[?^?x?[?X?Ŋ??p???????u?f?[?^?̕ی?v?Ɓu?Í????v?F?f?[?^?x?[?X?Z?L?????e?B?̊?b?̃L?\?i4?j - ??IT

Oracle?f?[?^?x?[?X?Ŋ??p???????u?f?[?^?̕ی?v?Ɓu?Í????v?F?f?[?^?x?[?X?Z?L?????e?B?̊?b?̃L?\?i4?j

» 2003?N12??05?? 00??00?? ???J

[?c?????C?C???^?[?l?b?g??????????]

?@?O??́u??3?? Oracle?f?[?^?x?[?X???????̃Z?L?????e?B?΍?̊?{?v?ł́AOracle?f?[?^?x?[?X?̓???????щ^?p???̊?{?I?ȃZ?L?????e?B?΍??Ƃɂ??Đ????????B????́AOracle9i?f?[?^?x?[?X?̊?{?@?\?𗘗p???āAOracle?f?[?^?x?[?X?̕ۑ??f?[?^??ی삷?鉼?z?v???C?x?[?g?f?[?^?x?[?X?ƕۑ??f?[?^?̈Í????ɂ??ďЉ??B

?@?????̃Z?L?????e?B?@?\?ɂ??ẮA???݂̂Ƃ???APostgreSQL??MySQL?Ƃ??????ق??̃t???[?\?t?g?E?F?A?ɑ΂???A?h?o???e?[?W?????邽?߁A???Њ??p???????@?\???B

??????

???????̃I?v?V???????i?𗘗p??????荂?x?ȃZ?L?????e?B?΍???\?????A?{?A?ڂł?Oracle 9i Enterprise Edition???C?Z???X?𗘗p???Ă??郆?[?U?[???s?????Ƃ??ł???Z?L?????e?B?΍?𒆐S?ɐ???????B

?ۑ??f?[?^?̕ی?Ƃ?

?@???܂??܂ȃZ?L?????e?B?΍???s????Oracle9i?f?[?^?x?[?X?ł????Ă??A?Ⴆ?΁A?Г??̕????̃??[?U?[?ɑ΂???Oracle9i?f?[?^?x?[?X??ʂ??ċƖ??T?[?r?X???񋟂???Ă???ꍇ?A???K???[?U?[?ł???Ύ????̋Ɩ??Ƃ͊֌W?̂Ȃ??f?[?^?ւ̃A?N?Z?X???\???i?A?v???P?[?V?????ȂǂŃA?N?Z?X??????????Ă???ꍇ?ł??ASQL*Plus?Ȃǂ̊Ǘ??c?[??????A?N?Z?X?????\????????j?B

?@????ɁAOracle9i?f?[?^?x?[?X???ɕۑ?????Ă???f?[?^?́ASQL????ł????߂΁A????ł??m?F???邱?Ƃ??ł???B??????Oracle9i?f?[?^?x?[?X?ł́A3?̑??ʂ???f?[?^?x?[?X???ɕۑ?????Ă???f?[?^?̕ی???s?????Ƃ??ł???i?\1?j?B

?E?ʐM?o?H?̈Í????iOracle Advanced Security?ɂĎ????\?j

?E?ۑ??f?[?^?ւ̃A?N?Z?X????

?E?ۑ??f?[?^?̈Í???

?\1 ?ۑ??f?[?^?̕ی???@
?i???????AOracle Advanced Security?ɂ??ẮA?L???I?v?V?????ł???j

?@?????̋@?\?𗘗p???邱?ƂŁA??O?҂???̕s???A?N?Z?X?ɑ΂??Ă??A?L???ȑ΍???s?????Ƃ??ł???BOracle9i?f?[?^?x?[?X???ɕۑ?????Ă???f?[?^?̕ی???@?ɂ??āA?A?N?Z?X?????ƈÍ????ɂ??΍???????ł͐??????邪?A?ʂ????Ăǂ??炪???ʓI???낤???BOracle9i?f?[?^?x?[?X?̐??i?\??????l????ƁA?f?[?^?̈Í????̕????????I???Ǝv????B

??????

?l?I?ɂ́A?A?N?Z?X????????????????????ʓI???Ǝv???B?Ȃ??Ȃ?΁A????͌???̐??i?\????Oracle Label Security?I?v?V???????w?????Ȃ???΃A?N?Z?X?????????ɔώG?ɂȂ邽?߂??B

?ۑ??f?[?^?ւ̍s?P?ʂ̃A?N?Z?X???????\?ƂȂ?
?u???z?v???C?x?[?g?f?[?^?x?[?X?v

?@Oracle9i?f?[?^?x?[?X?ł́A???z?v???C?x?[?g?f?[?^?x?[?X?iVirtual Private Database?j?@?\?𗘗p???邱?ƂŁA?ۑ??f?[?^?ւ̍s?P?ʂ̃A?N?Z?X???????\?ƂȂ?B

?@???z?v???C?x?[?g?f?[?^?x?[?X?ł́A???[?U?[???Ώۂ̃f?[?^?ɃA?N?Z?X????ꍇ?A?ǂ?ȃA?N?Z?X???@?ł????Ă??A?T?[?o????WHERE??i?????j??t??????SQL???????s????A????ɂ???ăA?N?Z?X?ł???͈͂??????????B

?@?????ł́A????f?[?^?ɑ΂??āA??????????SQL????v?????Ă??A???[?U?[?ɂ???āASQL???̏??????????I?ɕt?^????āA?o?͂???錋?ʂ??قȂ?B

?@?Ⴆ?΁A?}1?̂悤?ɁA?a?@?Ȃǂň?t???????̒S?????銳?҈ȊO?̃f?[?^?ɃA?N?Z?X?ł??Ȃ??悤?ɂ??邱?ƂŊ??҂̃v???C?o?V?[??????I?ɂ???邱?Ƃ??ł???悤?ɂȂ?B

?@???z?v???C?x?[?g?f?[?^?x?[?X?𗘗p????΁A?????̊?Ƃ̌ڋq???𓯈?C???X?^???X???ŊǗ????邱?Ƃ??ł??邾?낤?B

?}1 ?A?N?Z?X?͈͂𐧌??ł??鉼?z?v???C?x?[?g?f?[?^?x?[?X

?R???? ???z?v???C?x?[?g?f?[?^?x?[?X?@?\??ʂ̕??@?Ŏ???

???z?v???C?x?[?g?f?[?^?x?[?X?@?\?Ɠ????̋@?\???ق??̕??@?Ŏ???????ꍇ?A?u?r???[?v?𗘗p????B

?r???[?𗘗p???邱?ƂŁA?Ⴆ?΂???a?@?̊O?Ȃ̊??҂̏?񂾂??????o?????r???[???쐬???A?A?v???P?[?V???????炻?̕a?@?̊O?Ȉオ??????g???ꍇ?A?A?N?Z?X??????̃r???[?????Ɍ??肷?邱?ƂŁA?O?ȈȊO?̊??҂̏??ւ̃A?N?Z?X?𐧌????邱?Ƃ??ł???B

???????A???̕??@?̏ꍇ?A???[?U?[???ƂƏ??????ƂɃr???[?????O?ɗp?ӂ???K?v??????̂ŁA???[?U?[?????????ꍇ?Ȃǂ͂??܂茻???I?ł͂Ȃ??B

?}2 ?r???[?ɂ??A?N?Z?X?????C???[?W

???z?v???C?x?[?g?f?[?^?x?[?X?̊T?v

?@?ł́A???ɊȒP?ł??邪?A???z?v???C?x?[?g?f?[?^?x?[?X?̊T?O?????????B???z?v???C?x?[?g?f?[?^?x?[?X?́A?A?v???P?[?V?????R???e?L?X?g?ƃt?@?C???O?????E?A?N?Z?X?E?R???g???[???iPL/SQL?p?b?P?[?W?𗘗p???āAWHERE??????ݒ肷?邱?Ƃ??ł???j??2?̋@?\????\??????Ă???i????2??g?ݍ??킹?邱?Ƃ????z?v???C?x?[?g?f?[?^?x?[?X?Ƃ????j?B

$?}3 ???z?v???C?x?[?g?f?[?^?x?[?X?̍\???C???[?W$ ?}3 ???z?v???C?x?[?g?f?[?^?x?[?X?̍\???C???[?W

???A?v???P?[?V?????R???e?L?X?g

?@?A?v???P?[?V?????R???e?L?X?g?Ƃ́A?Z?b?V??????̑????????i?[???邽?߂̃f?[?^?ۑ??̈?ŁA???z?v???C?x?[?g?f?[?^?x?[?X?̃A?N?Z?X?????Ȃǂ??i?[???Ă???B

?@???z?v???C?x?[?g?f?[?^?x?[?X?ł̓??[?U?[?̃A?N?Z?X?????ɍ???????????쐬???邽?߂ɃA?v???P?[?V?????R???e?L?X?g?𗘗p????B?A?v???P?[?V?????R???e?L?X?g?́A?A?v???P?[?V?????R???e?L?X?g???A?????A?l??3?̗v?f????\??????Ă???B

?@?܂??A1?̃A?v???P?[?V?????R???e?L?X?g?ɂ́A?????̑????????Ă?B?Ⴆ?΁A???ҏ????i?[????PATIENT_DATA?Ƃ??????O?̃A?v???P?[?V?????R???e?L?X?g???쐬???A?ȕ??喼?A?S??????A???ꂼ??SURGERY?ADOCTOR?Ƃ????????Œl??ێ??ł???B

???t?@?C???O?????E?A?N?Z?X?E?R???g???[??

?@?t?@?C???O?????E?A?N?Z?X?E?R???g???[???́ASQL?????s???Ɏ??O?ɐݒ肳??Ă????????t?^???邱?Ƃɂ??A?A?N?Z?X????????s????B

?}4 ?t?@?C???O?????E?A?N?Z?X?E?R???g???[???C???[?W?i???????ɂ??A?A?N?Z?X???䂳??Ă???j

?@????????́A?ۑ??f?[?^?̕ی?̂???????̃Z?L?????e?B?΍?ł???f?[?^?̈Í????ɂ??Đ???????B

?ۑ??f?[?^?̈Í???

?@Oracle?f?[?^?x?[?X???ɕۑ?????Ă???f?[?^?́A?Í??????邱?Ƃŕs???A?N?Z?X????ی삷?邱?Ƃ??ł???i?Í????́A?J?????P?ʂŎ??????邱?Ƃ??\?j?B???̈Í????ɂ??ẮADBMS_OBFUSCATION_TOOLKIT?ɓY?t????Ă???PL/SQL?p?b?P?[?W?𗘗p???邱?ƂŎ????ł???B


??̈Í?	DESEncrypt DES3Encrypt
??̕???	DESDecrypt DES3Decyrypt
??ł̃`?F?b?N?T???̍쐬?ɂ??f?[?^?̐??????̕ۏ?	MD5
?\2 DBMS_OBFUSCATION_TOOLKIT?p?b?P?[?W?Ɋ܂܂??v???O?????E???j?b?g

?@PL/SQL?p?b?P?[?W?́ADES?iData Encryption Standard?j?????3DES?ƌĂ΂??A???S???Y???ňÍ??????邱?Ƃ??ł???B?܂??AMD5?iMessage Digest 5?j?𗘗p???āA?f?[?^???n?b?V?????i???????j???s?????Ƃ??ł???B

?@?f?[?^?̈Í???????ѕ????̍ł??ȒP?ȕ??@?́ADESEncrypt?v???V?[?W??????сADESEncrypt?v???V?[?W???̗??p?ł???B

?EDES?A???S???Y???ɂ??Í???

dbms_obfuscation_toolkit.DESEncrypt(
?@?@input_string => v_input_string,
?@?@key_string => v_key_string,
?@?@encrypted_string => v_encrypted_string)

?EDES?A???S???Y???ɂ?镜??

dbms_obfuscation_toolkit.DESDecrypt(
?@?@input_string => v_encrypted_string,
?@?@key_string => v_key_string,
?@?@decrypted_string => v_decrypted_string)

?@?܂?DES?A???S???Y???́A56?r?b?g?̌????g?p???A?f?[?^??64?r?b?g?̃u???b?N?P?ʂňÍ???????B?܂??ADESEncrypt?v???V?[?W???????DESDecrypt?v???V?[?W???ł́Akey_string?p?????[?^??64?r?b?g?̌???񋟂???K?v?????邱?Ƃ?t???????Ă????B

?R???? ?ۑ??f?[?^?̈Í????̃????b?g

Oracle9i?f?[?^?x?[?X?ɕۑ?????Ă???f?[?^???Í???????K?v??????̂??Ǝv???ǎ҂??????邩??????Ȃ??B????܂ŘA?ڂŐ??????Ă????l?b?g???[?N????уT?[?o?̃Z?L?????e?B?΍???s???A?????Oracle9i?f?[?^?x?[?X?̃Z?L?????e?B?΍???s???Ă??A?܂??Z?L?????e?B?΍???s??Ȃ???΂Ȃ?Ȃ??̂??ƁB

?Í????́A???܂܂Ő??????Ă????Z?L?????e?B?΍??̖??ɑ΂???\?????[?V?????ł?????A???????f?[?^?x?[?X?ɃA?N?Z?X?ł?????????[?U?[?ɑ΂???Z?L?????e?B?\?????[?V?????Ƃ??Ă??̃????b?g?𗝉?????K?v??????Ǝv???B

?Ⴆ?΁A?????O?ɘb??ɂȂ????Z??l?b?g?i?Z????{?䒠?l?b?g???[?N?j?̏ꍇ???O??????̃A?N?Z?X?ɑ΂???Z?L?????e?B?΍?ɂ??ẮA????????s???Ă???悤?????A?ʂ????Ăǂ̂??炢?̎s????????œ???????̕s???A?N?Z?X?ɑ΂??Ė??S?ȑ΍􂪎???Ă??邩?͕s???ł???B

???̂悤?ȏꍇ?ɁA?ۑ??f?[?^?̏d?v?Ȃ??̂??Í??????Ă????΁A??????s???A?N?Z?X???s???Ă??A???ꂪ???̂܂܏d?v?ȃf?[?^?̘R?????ɂ͂Ȃ???Ȃ????Ƃ??Ӗ?????iOracle9i?f?[?^?x?[?X?̏ꍇ?A?Í????𗘗p???ăf?[?^?̈Í??????s???Ă???̂ŁA???̌??ɑ΂??ĕs???A?N?Z?X???????ɍs??ꂽ?ꍇ?́A???̌???ł͂Ȃ??j?B

?R???? ?ʐM?f?[?^?̈Í????̃??C?Z???X?`??

Oracle9i?f?[?^?x?[?X?ł́A?ۑ?????Ă???f?[?^?̈Í????ɂ??ẮAOracle9i Standard Edition?????Enterprise Edition?ȂǃT?[?o?̃??C?Z???X?`?Ԃɂ?????炸???p?ł??邪?A?ʐM?f?[?^?̈Í????????????邽?߂ɂ́A?ʓrOracle Advanced Security Option???w??????K?v??????B

???̓_?ŁAOracle9i?f?[?^?x?[?X?̐??i???C???A?b?v?Ƃ??āA??{?I?ȃZ?L?????e?B?΍?@?\?ɂ??ẮA?T?[?o???C?Z???X?w???҂ɑ΂??Ē񋟂??邱?Ƃ??ł???΁AOracle?f?[?^?x?[?X?̃Z?L?????e?B?΍?ɂ??āA??т????΍???s?????Ƃ??ł?????̂ƕM?҂͍l???Ă???B

???̂?????ɂ??Ď????o?[?W?????łǂ??????????C?Z???X?`?ԂɂȂ邩?????Г??{?I???N???Ɍ??????Ă????????????Ǝv???B

??????グ???A???z?v???C?x?[?g?f?[?^?x?[?X?ɂ??Ă????p???Ă??郆?[?U?[?͔??ɏ??Ȃ????Ǝv????iOracle9i?f?[?^?x?[?X?ł́AOracle Label Security?????z?v???C?x?[?g?f?[?^?x?[?X?̊g???@?\?Ƃ??Ē񋟂???Ă???B?Ȃ??A????Љ?Ȃ?????Oracle Label Security?𗘗p????ꍇ?́A Oracle9i Enterprise Edition?Ƃ͕ʂɍw??????K?v??????j?B

????ɁA?ڍ׏??ɂ??ẮAOracle Technology Network Japan???Oracle?f?[?^?x?[?X?̃I?????C???}?j???A???Ȃǂ????邱?Ƃœ????邾?낤?B?܂??AOracle9i?ɕ??L???Z?L?????e?B?΍?@?\?????邱?Ƃ𗝉??????????ŁA?V?X?e???\?z?̍ۂ̎Q?l?ɂ??Ă??炦??΍K?????B

??????

Advanced Security Option?́AOracle9i Enterprise Edition?̃I?v?V???????i?ł???B

?@???????????????낤???B????̋L???ɂ??AOracle9i?f?[?^?x?[?X?̕ۑ??f?[?^?̃Z?L?????e?B?΍?@?\?̊T?v?͗????ł????̂ł͂Ȃ????낤???B???z?v???C?x?[?g?f?[?^?x?[?X?ƕۑ??f?[?^?̈Í????ɂ??ẮA?Ɩ??ŗ??p?????ʂ͏??Ȃ?????????Ȃ????AOracle9i?f?[?^?x?[?X?ł???Ȃ??Ƃ??ł???Ƃ????Ӗ??ō??񂲏Љ???B

?@????́AOracle?f?[?^?x?[?X?̊č??@?\???Љ?????Ǝv???B

?u??3??v??

?u??5??v??