CARVIEW |
?????ƍs??}??????f?[?^?x?[?X?č??F?f?[?^?x?[?X?Z?L?????e?B?̊?b?̃L?\?i5?j
?@?u??4??Oracle?f?[?^?x?[?X?Ŋ??p???????w?f?[?^?̕ی?x?Ɓw?Í????x?v?ł́AOracle?f?[?^?x?[?X?̈Í????@?\?𗘗p?????ۑ??f?[?^?̈Í????ɂ??Đ????????B????́A?f?[?^?x?[?X?č??܂?ۑ??f?[?^???Ď????邽?߂̋@?\?ɂ??ďЉ??B
?f?[?^?x?[?X?č??̌??ʂƂ?
?@?Ȃ??A?f?[?^?x?[?X?č????s???̂??낤???H ?????A?ڋq???ی?̏d?v????????Ă???A?Г??̃??[?U?[????̕s???s?ׂ??ڋq??o?̌????̑啔?????߂Ă???Ƃ?????????A?f?[?^?x?[?X?č??͎Г??????N?????m?V?X?e???iIDS?j?̂悤?Ȉʒu?t???ƂȂ蓾??Ƃ??????Ƃ????邽?߂??B
?@?܂??A?f?[?^?x?[?X?č??̗??p???ʂƂ??āA???ӂ????????Г????[?U?[?Ȃǂ̃f?[?^?x?[?X?ւ̕s???ȓ?????Ď??i?L?^?E???v?j????ƂƂ??ɁA?f?[?^?x?[?X?č????Ă???Ƃ??????Ƃ??Г??I?ɃA?i?E???X???邾???ŁA??????x?̗}?~???ʂ??????ɐ??ނ??Ƃ??l??????B??
??Oracle?f?[?^?x?[?X?ɂ??č??̑Ώ?
?@Oracle?f?[?^?x?[?X?ł́A?f?[?^?x?[?X?ɑ???A?N?Z?X??X?V?Ȃǂ̂??܂??܂ȃA?N?V???????L?^????č??@?\??????Ă???B???̊č??ΏۂƂ??āA?ȉ??̂悤?ȕ??ނōs?????Ƃ??ł???B
- ???č??i?????SQL???̊č????ʂɐݒ?j
- ?V?X?e???????č??i90??ވȏ?̃V?X?e?????????ʂɐݒ?j
- ?I?u?W?F?N?g?č??i????̃I?u?W?F?N?g?ɑ???SQL???̎??s???č??j
?@????ɁA?????̑Ώۂ??ƂɈȉ??̂悤?Ȑݒ???????čs?????Ƃ??ł??邽?߁A?p?r?ɍ??????č????s?????Ƃ??ł???B
- ?č?????ΏۂƂ??ē???̃??[?U?[??ݒ肷??A?܂??͂??ׂẴ??[?U?[??ݒ肷??
- ????SQL???????s???ꂽ?ꍇ?A?Z?b?V?????P?ʂ?1?x?̂݊č????s???A?܂???SQL?????ƂɊč?????
- ?č????s???ꍇ?A???????݂̂ɊǗ??҂֒ʒm????A?܂??͎??s???̂݁A???邢?͗????̏ꍇ?ʒm???邱?Ƃ??\
?@?܂??AOracle?f?[?^?x?[?X?č??@?\?ɂ́AOracle8i?ȑO???????Ă???u?f?[?^?x?[?X?č??v??Oracle9i???瓱?????ꂽ?u?t?@?C???O???C???č??v?????邽?߁A??قǏڂ????Љ?邱?Ƃɂ???B
?@?\ | ?T?v |
---|---|
?f?[?^?x?[?X?č? | ?I?u?W?F?N?g???x???i?\?E?r???[?Ȃǁj?č????s???B |
?t?@?C???O???C???č? | Oracle9i Database Enterprise Edition?ł̂ݗ??p?ł???@?\?B?I?u?W?F?N?g?ɓo?^????Ă???f?[?^?̒l????Ɋč????s?????Ƃ??ł???B |
?\1 ?f?[?^?x?[?X?č??ƃt?@?C???O???C???č??̈Ⴂ |
?@?ł́A??{?I?ȃf?[?^?x?[?X?č??ɂ??Đ??????悤?B
?f?[?^?x?[?X?č??̐i?ߕ?
?@?܂??A?f?[?^?x?[?X?č???i?߂?ɓ??????Č??߂Ȃ???????Ȃ??̂??A???̂??߂Ƀf?[?^?x?[?X?č??????{????̂??A?Ƃ????č??̖ړI?ɂȂ?B?ł́A?ȉ??̃t???[?ɏ]?????̐i?ߕ?????????Ă????B
???f?[?^?x?[?X?č??̖ړI?m??????
?@?ނ?݂₽??Ƀf?[?^?x?[?X?č????s???Ă????ǂ͈Ӗ??̂Ȃ????̂ɂȂ??Ă??܂????߁A?ړI?m?ɂ??邱?Ƃŕs?K?v?ȃf?[?^?x?[?X?č????s?킸?ɍςނ??ƂɂȂ?B???ʂƂ??č?ƑS?̂̎??ԂƃR?X?g??Z?k?ł???B
?@?ł́A?K?v?Ȃ??̂??????č?????ɂ͂ǂ?ȓ_?ɒ??ڂ???悢?̂??낤???B?Ⴆ?AWeb?T?[?o?̃??O??????Ƃ??ɂ́A???????????̂ł͂Ȃ??A?G???[???N???????̂????邱?Ƃŕs???A?N?Z?X?̗L?????m?F?ł???B?f?[?^?x?[?X?č??ɂ??Ă????l?̂??Ƃ??????邾?낤?B
?@?܂????߂ɁA?????Ă?????̏d?v????f?[?^?̐????ɂ???ĉ????č??i?Ď??j???邩?????肷??K?v??????B?Ⴆ?A?ڋq???Ȃǂ̊Ǘ??V?X?e???Ȃǂɂ??ẮA?ڍׂȃf?[?^?x?[?X?č????s???K?v?????邪?A?V?X?e???S?̂̃??O???f?[?^?x?[?X?ɉ??X?Ə???????ł??郍?O?e?[?u???i?I?u?W?F?N?g?j?ɂ??ẮA???ׂ??Ɋm?F????K?v?͂Ȃ??Ȃǂ̂悤?ɁA?č?????ړI?Ƃ??ďd?v?Ȃ??Ƃ͉?????????????ƌ??ɂ߂Ă????K?v??????B
???f?[?^?x?[?X?č??Ώۂ̌???
?@?f?[?^?x?[?X?č??̖ړI??????ł?????A???̓f?[?^?x?[?X?č????s???Ώۂ????肷??B?????ł́A?Ǘ????[?U?[?̐ݒ???@?Ɗe?I?u?W?F?N?g?ɑ???f?[?^?x?[?X?č????@?ɂ??Đ???????B
?E?Ǘ????[?U?[?̂??߂̐ݒ?
?f?[?^?x?[?X?Ǘ??҂́A?f?[?^?x?[?X?Ɋւ??邳?܂??܂ȑ?????s?????Ƃ??ł???B???̂??߁A??ʃ??[?U?[?Ƃ͕ʂɊǗ????[?U?[?̊č????s?????Ƃ??ł???B
?Ⴆ?A?ʏ?A?f?[?^?x?[?X?̋N???E??~?Ȃǂ̏??ɂ??ẮA$ORACLE_HOME/admin/ORALCE_SID.log?ɏ??????܂??B
??????
$ORACLE_HOME?ɂ??ẮAOracle9i?̃C???X?g?[???????ƂɈقȂ?̂ŁA?????Ƃɓǂݑւ??Ă????????????B
?܂??AOracle9i?f?[?^?x?[?X?ł̓f?t?H???g?ł???SYS???[?U?[?Ƃ??Đڑ??????Z?b?V?????́AAUDIT_SYS_OPERATIONS???????p?????[?^?𗘗p???邱?ƂŁAOS?ɏ??????ނ??Ƃ??ł???B
AUDIT_SYS_OPERATIONS = TURE
??????
?f?t?H???g?́AFALSE?ɂȂ??Ă???B
?E?e?I?u?W?F?N?g?ɑ???f?[?^?x?[?X?č??ݒ???@
?f?[?^?x?[?X?č????s???ꍇ?A?܂??č????\?ȏ?ԂɃf?[?^?x?[?X??ݒ肵?Ȃ???Ȃ?Ȃ??B???̂????ŁA?č??ɕK?v??SQL???s???邱?ƂŊč????O?̎擾???\?ƂȂ邽?߁A?ȉ??̎菇?Őݒ肷??K?v??????B
?܂??A?e?I?u?W?F?N?g?ɑ???f?[?^?x?[?X?č??̂??߂̃p?????[?^?ɂ??Đ???????BOracle9i?f?[?^?x?[?X?̃f?[?^?x?[?X?č??ɂ́A????̃I?u?W?F?N?g?ɑ???č??ƌ?????SQL???Ɋւ??錠????????B?ȉ??͂??̗??p?????Ɋւ???p?????[?^?ł???i?\2?j?B
???????p?????[?^ | ?ڍ? |
---|---|
AUDIT_TRAIL | ?f?[?^?x?[?X?č????g?p?\?E?֎~?ɂ???B |
AUDIT_FILE_DEST | AUDIT_TRAIL=OS???ݒ肳??Ă???ꍇ?A?f?[?^?x?[?X?č????ۑ??????f?B???N?g?????w?肷??B |
?\2 ???p?????Ɋւ???p?????[?^?i???????p?????[?^?j |
??????
???????p?????[?^AUDIT_SYS_OPERATIONS?AAUDIT_TRAIL?AAUDIT_FILE_DEST?́A?ÓI?p?????[?^?̂??߁A?f?[?^?x?[?X?̍ċN?????K?v?ł???B
?Ⴆ?A?č????O??/var/oracle/log?f?B???N?g???ȉ??ɏ??????ޏꍇ?́A?ȉ??̂悤?ɂ???B
AUDIT_FILE_DEST=/var/oracle/log
?E?č??̎g?p?\????юg?p?֎~
AUDIT_TRAIL?p?????[?^?́A?f?[?^?x?[?X?č??̎g?p?\????юg?p?֎~?̐ݒ???s?????Ƃ??ł???B???̐ݒ???s??Ȃ??ƃf?[?^?x?[?X?č????s?????Ƃ??ł??Ȃ??B
?܂??A???̃p?????[?^?́A?č????e?̏??????ݐ???w?肷??ꍇ?ɂ????p?????B?Ⴆ?A???̐ݒ?l??DB?ɂȂ??Ă???ꍇ?́A?f?[?^?x?[?X?̊č??ؐՕ\?i?X?L?[??SYS.AUD$?\?j?Ɋč????R?[?h???i?[?????B
?ݒ?l | ?ڍ? |
---|---|
DB | ?f?[?^?x?[?X?č????g?p?\?ɂ???B?f?[?^?x?[?X?č??́A?f?[?^?x?[?X???ɕۑ??????B |
OS | ?f?[?^?x?[?X?č????g?p?\?ɂ???B?f?[?^?x?[?X?č??́A ?I?y???[?e?B???O?V?X?e???̃t?@?C???Ƃ??ĕۑ??????B |
NONE | ?f?[?^?x?[?X?č????g?p?֎~?ɂ???B |
?\3 AUDIT_TRAIL?p?????[?^ |
??????
?č???????ɂ?AUDIT SYSTEM???????K?v?ł???B
?Ⴆ?AOS?t?@?C???V?X?e????Ɋč????O?????????ޏꍇ?́A?ȉ??̂悤?ɂ???B
AUDIT_TRAIL=OS
?E???̂ق??̃I?v?V????
?f?[?^?x?[?X?č????s???ɓ??????āA???????̃I?v?V???????w?肷?邱?Ƃ??ł???B??\?I?Ȃ??̂́A?č????O?̎擾?^?C?~???O?Ǝ擾?P?ʂ?????B?Ȃ??A?????p?????[?^?ɂ??ẮA?č??I?v?V?????ݒ莞?ɗ??p????I?v?V?????ƂȂ?B
?i1?j?č????O?擾?^?C?~???O
???????Ɋč????O???擾???邩?A???s???Ɋč????O???擾???邩??ݒ肷??p?????[?^??????BWHENEVER SUCCESSFUL???w?肷???SQL?????????????ꍇ?݂̂??f?[?^?x?[?X?č??ΏۂƂ???B
WHENEVER NOT SUCCESSFUL???w?肷??ƁASQL???????s?܂??̓G???[???????????ꍇ?̂݃f?[?^?x?[?X?č??̑ΏۂƂȂ?B
?Ⴆ?A???????̂݊č????O???擾????ꍇ?́A?ȉ??̂悤?ɂ???B
AUDIT SELECT ON CUSTOMER.CUSTOMER_MAIN WHENEVER SUCCESSFUL;
?i2?j?č????O?擾?P??
?č????O?̎擾?P?ʂ?ݒ?ł???p?????[?^??????BBY SESSION?́A????Z?b?V???????̂??ׂĂ?SQL?????P?ꃌ?R?[?h?ɏ??????܂??BBY ACCESS???w?肷??ƁA?A?N?Z?X???ƂɃ??R?[?h?????????܂??B
?Ⴆ?A?A?N?Z?X???ƁiSQL???????????邲?ƂɁj?Ɋč????O???܂Ƃ߂?ꍇ?́A?ȉ??̂悤?ɂ???B
AUDIT SELECT ON CUSTOMER.CUSTOMER_MAIN BY ACCESS
?f?[?^?x?[?X?č??̎??ۂ̐ݒ?
?@??قǐ????????悤?Ƀf?[?^?x?[?X?č????\?ȏ?Ԃɂ???ɂ́AAUDIT_TRAIL?p?????[?^?ɂ???Ċč??\?ɂ?????ŁAAUDIT?R?}???h?𗘗p???Ċč????J?n????K?v??????B?????ł́A???ۂ̐ݒ???@?ɂ??āA??\?I?ȗ???????Ȃ?????????悤?B
?????[?U?[?ɂ??₢???킹
?@?܂??A????̃??[?U?[?̖₢???킹?ɂ??ăf?[?^?x?[?X?č????s?????@????????悤?B???̏ꍇ?̓???̃??[?U?[?Ƃ́AOracle9i?f?[?^?x?[?X???ł̃??[?U?[?ɂȂ邽?߁A?f?[?^?x?[?X?ɃA?N?Z?X?????̂??郆?[?U?[??A?v???P?[?V?????T?[?o?o?R?ȂǂŃA?N?Z?X???s?????[?U?[???w?肷?邱?ƂŁA????̃??[?U?[?̖₢???킹???e???m?F???邱?Ƃ??ł???B
?@?Ⴆ?A???[?U?[SCOTT???f?[?^?x?[?X?ɐV?????\???lj????ꂽ???Ƃ??č?????ɂ́A?ȉ??̂悤?ɂ???B
AUDIT CREATE TABLE BY SCOTT;
?@BY SCOTT?ɂ??ẮA?ق??̃??[?U?[???ɒu???????邱?Ƃ??ł???B????ɁA?????̃??[?U?[?̐ݒ肪?K?v?ȏꍇ?́A?ȉ??̂悤?ɁuBY ???[?U?[??,???[?U?[???v?ƋL?q????B
AUDIT CREATE TABLE BY SCOTT,BOB;
???I?u?W?F?N?g?i?\?j?ɑ???₢???킹
?@???ɏd?v?Ȍڋq???e?[?u???Ȃǂ̂??????̃I?u?W?F?N?g?i?\????уr???[?j?ւ̃A?N?Z?X???č?????悤?ȏꍇ?́A?č??̑ΏۂɃI?u?W?F?N?g?i?\?j???w?肷??K?v??????B
?@?Ⴆ?A?X?L?[?}CUSTOMER??CUSTOMER_MAIN???̂??ׂĂ̖₢???킹??SQL???ɂ??ăf?[?^?x?[?X?č????s???B
AUDIT SELECT ON CUSTOMER.CUSTOMER_MAIN
?@?X?L?[?}CUSTOMER????CUSTOMER_MAIN???̂??ׂĂ̖₢???킹??????ɏI?????????ׂĂ̖₢???킹??SQL???ɂ??ăf?[?^?x?[?X?č????s???B
AUDIT SELECT ON CUSTOMER.CUSTOMER_MAIN WHENEVER SUCCESSFUL;
???f?t?H???g?č??I?v?V????
?@?Ƃɂ????A?????????I?u?W?F?N?g??[?U?[?ȂNjC?ɂ????f?[?^?x?[?X??̃A?N?V?????ɑ??ăf?[?^?x?[?X?č????s???????ꍇ?́A?č??f?t?H???g?I?v?V???????w?肷??B???????A?f?[?^?x?[?X?č??́A??قǂ??????????悤?ɁA?K???č????O?̏??????݂?OS?t?@?C???܂??̓f?[?^?x?[?X??ōs?????߁A?T?[?o?ɑ??ĕ??ׂ??|????B???̂??ߐݒ莞?ɂ͐ݒ???e???悭?ᖡ????K?v?????邾?낤?B
?@?Ⴆ?A?\???쐬?????ꍇ?AALTER???AINSERT???AUPDATE?????????I?Ƀf?[?^?x?[?X?̊č??ΏۂɂȂ?B
AUDIT ALTER,INSERT,UPDATE,DELETE ON DEFAULT;
???č??R?}???h?̗L????????і?????
?@??x?ݒ肵???č??R?}???h??ύX????K?v?????邩??????Ȃ??B?Ⴆ?A?ΏۂƂ???I?u?W?F?N?g?̒lj???폜??????ɓ?????B???̏ꍇ?ANOAUDIT?R?}???h?𗘗p???Ċč????~????i?č??̊J?n?ɂ́AAUDIT?R?}???h?𗘗p????j?B
?@?Ⴆ?A?X?L?[?}CUSTOMER??CUSTOMER_MAIN?\?̍X?V?ɑ??ăf?[?^?x?[?X?č????s???B
AUDIT UPDATE ON CUSTOMER.CUSTOMER_MAIN
?@???̃f?[?^?x?[?X?č??I?v?V???????ɂ??邽?߂ɂ́A?ȉ??̂悤?Ȑݒ???s???B
NOAUDIT UPDATE ON CUSTOMER.CUSTOMER_MAIN
??????
NOAUDIT???????s???Ă??č??I?v?V?????̐ݒ肪????????邾???ŁA?č??@?\???̂??g?p?֎~?ɂȂ?킯?ł͂Ȃ??B?f?[?^?x?[?X?č??@?\???̂????S?ɒ?~????ɂ́A?????p?????[?^AUDIT_TRAIL?̐ݒ??ύX????K?v??????B
?@???ׂĂ̊č????g?p?֎~?ɂ???ɂ́A?ȉ??̂悤?Ȑݒ???s???B???̃R?}???h?ɂ??A???ׂĂ̊č??R?}???h???????ɂȂ?B
NOAUDIT ALL;
?č????e?̊m?F
?@?f?[?^?x?[?X?Ɋč????e?????????܂??ꍇ?́ASYS.AUD$?ɏ??????܂??B?????ɂ́A???܂??܂ȏ???????܂?邽?߁A??̓I?ȕ\?????s?????߂̂??????̃r???[???쐬????K?v??????B???̃r???[?́ACATALOG.SQL?????CATAUDIT.SQL?X?N???v?g????쐬???邱?Ƃ??ł???B
?r???[ | ?ڍ? |
---|---|
AUDIT_ACTIONS | ?č??̃A?N?V?????E?^?C?v?E?R?[?h???L?q?????B |
DBA_AUDIT_TRAIL | ?č????w?肳??Ă??邷?ׂẴG???g???[???\???????B |
DBA_STMT_AUDIT_OPTS | ???ׂẴV?X?e???č??I?v?V???????\???????B |
DBA_PRIV_AUDIT_OPTS | ???ׂẴI?u?W?F?N?g?̊č??I?v?V???????\???????B |
DBA_AUDIT_OBJECT | ???ׂĂ̊č????R?[?h???\???????B |
?\4 ?č????e?m?F?p?r???[ |
?@?Ⴆ?A?ȉ??ɋL?????悤?ɁA?č????ʂ?OS?t?@?C???ɏ????o???????̂ɂȂ?B???????p?????[?^AUDIT_TRAIL=OS?Őݒ肵???ꍇ?̌??ʂƂȂ?A?????ł́ASYS?X?L?[?}??DBA_USERS??SELECT????ɑ??Ċč???ݒ肵?ASYSTEM???[?U?[?????Y?I?u?W?F?N?g?ɑ???SQL???????s?????ꍇ?̌??ʂɂȂ?B
select * from dba_users; ======================================================================== [ora920@localhost oracle]$ cat ora_13484.aud Audit file /var/oracle/ora_13484.aud Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production ORACLE_HOME = /usr/oracle/product/9.2.0 System name: Linux Node name: localhost.localdomain Release: 2.4.9-e.9.30ml Version: #1 Mon Jan 20 19:24:39 JST 2003 Machine: i686 Instance name: home1920 Redo thread mounted by this instance: 1 Oracle process number: 14 Unix process pid: 13484, image: oracle@localhost.localdomain (TNS V1-V3) Mon Feb 23 01:39:29 2004 SESSIONID: "112" ENTRYID: "1" STATEMENT: "7" USERID: "SYSTEM" TERMINAL: "pts/1" ACTION: "103" RETURNCODE: "0" OBJ$CREATOR: "SYS" OBJ$NAME: "DBA_USERS" SES$ACTIONS: "---------S------" SES$TID: "1874" OS$USERID: "ora920"
?t?@?C???O???C???č?
?@???܂܂Ő??????Ă???Oracle8i?f?[?^?x?[?X?܂ł̃f?[?^?x?[?X?č??@?\?́A?I?u?W?F?N?g?P?ʁi???[?U?[?P?ʁj?ł????f?[?^?x?[?X?č??Ώۂ?ݒ肷?邱?Ƃ??ł??Ȃ??????BOracle9i?f?[?^?x?[?X????V?????t?@?C???O???C???č??????????ꂽ???Ƃŗ?P?ʂ???уf?[?^?l?ɂ??n???h?????O???܂߁A?f?[?^?x?[?X?č??̑ΏۂƂ??邱?Ƃ??ł???悤?ɂȂ????B
??????
???????A?t?@?C???O???C???č??́AOracle9i Enterprise Edition?݂̂ŗ??p?ł???@?\?ł???B
?R???? ?f?[?^?x?[?X?g???K?𗘗p?????č??@?\
Oracle9i?f?[?^?x?[?X?ȑO?ł??f?[?^?x?[?X?g???K?𗘗p???????O?擾?͂悭???p????Ă????B?i?[????Ă???l?ɕύX?????????ꍇ?ɁA???O?????????ރg???K?Ȃǂ͕M?Ҏ??ۂ?Oracle?ɐG??n?߂̂??????????Ƃ?????B
?Ⴆ?A?ȉ??̃f?[?^?x?[?X?g???K?́A?ڋq?????̕ύX?????????ꍇ?̂݁A????̕\?Ƀf?[?^?????????ރg???K?ɂȂ??Ă???B?]?k?ł͂??邪?A?f?o?b?O?ɂ??Ȃ?̃N?Z?̂???PL/SQL?ł??邪?A?f?[?^?x?[?X?̃p?t?H?[?}???X??L???Ɏg???Ƃ????Ӗ??ł́A???ɂ????c?[???ł???BJava?n?̃A?v???P?[?V?????ł?PL/SQL?v???V?[?W?????L?b?N????悤?Ȏg?????????Ă???T?C?g??????B
CREATE TRIGGER AUDIT_CUSTOMER_MAIN AFTER INSERT OR DELETE OR UPDATE ON CUSTOMER_MAIN FOR EACH ROW BEGIN IF (:NEW.CUSTOMER_NAME != OLD.CUSTOMER_NAME) THEN INSERT INTO AUDIT_CUSTOMER VALUES (:CUSTOMER_ID,:OLD.CUSTOMER_NAME,:NEW.CUSTOMER_NAME); ENDIF; END;
?@?t?@?C???O???C???č??̗??p?ɂ??ẮA?ȉ??̐}?̂悤?ȗ???ɂȂ?B
???t?@?C???O???C???č??̐ݒ?
?@?t?@?C???O???C???č??̐ݒ?̗???ɂ??ẮA?}4????????????????Α?̗???????ނ??Ƃ??ł???Ǝv???B?T?O?͔??ɃV???v???????A?P????SQL???ł͂Ȃ?PL/SQL?p?b?P?[?W???g?????߁A??????ƂƂ????ɂ?????????????Ǝv???B?ȉ??ɋL?????t?@?C???O???C???č??̐ݒ?ɂ́ADBMS_FGA?p?b?P?[?W?𗘗p????B??????4??ނ????Ȃ??̂??H ?Ƃ??????????邩??????Ȃ????A?p?????[?^?????????ߔY?ނ??Ƃ????邩??????Ȃ??B4?̃v???V?[?W???͂??ꂼ???قǂ̃f?[?^?x?[?X?č??Ɠ˂????킹?Č???Ƃ悢???낤?i?ق?1??1?̊W?ɂȂ??Ă???j?B
?v???V?[?W???? | ?ڍ? |
---|---|
DBMS_FGA.ADD_POLICY?v???V?[?W?? | ?č??|???V?[??lj?????B |
DBMS_FGA.DROP_POLOCY?v???V?[?W?? | ?č??|???V?[???폜????B |
DBMS_FGA.ENABLE_POCLCY?v???V?[?W?? | ?č??|???V?[??L????????B |
DBMS_FGA.DISABLE_POLICY?v???V?[?W?? | ?č??|???V?[????????B |
?\5 DBMS_FGA?p?b?P?[?W |
???t?@?C???O???C???č??̒lj?
?@?????ł́A?t?@?C???O???C???č??̒lj????@?ɂ??Đ??????悤?B???߂?DBMS_FGA.ADD_POLICY?v???V?[?W????p???Ċč??|???V?[??ݒ肷?邱?Ƃŗ??p?ł???B?ȉ??̗?ł́A?uPEFR_CODE=12?i?????s?j?v?̒n?悾?????č??̑ΏۂƂ???ꍇ?̎w????@??\???B???̏ꍇ?A?uPERF_CODE=12?v?ȊO?̒n??͊č??̑Ώۂ??珜?O?????B
DBMS_FGA.ADD_POLICY( OBJECT_SCHEMA => 'CUSTOMER', OBJECT_NAME => 'CUSTOMER_MAIN', POLICY_NAME => 'AUDIT_CUSTOMER_MAIN', AUDIT_CONDITION => 'PREF_CODE = '12' AUDIT_COLUMN => 'CUSTOMER_ID');
??????
AUDIT_COLUMN?ɂ??ẮASELECT??̏????ɂ???āA?č??ΏۂɂȂ?ꍇ?ƂȂ?Ȃ??ꍇ??????B
?y?Q?l?z?č??ΏۂƂȂ?SQL???ƑΏۂƂȂ?Ȃ?SQL??
???č??ΏۂƂȂ?SQL??
AUDIT_COLUMN?Ɏw?肵?Ă???CUSTOMER_ID??SELECT??̎w?蕶????*?i???ׂẴJ?????j????v???邽?߁A?č??ΏۂƂȂ?SQL???B
SELECT * FROM CUSTOMER_CUSTOMER_MAIN WHERE PREF_CODE = 12
???č??ΏۂƂȂ?Ȃ?SQL??
??قǂ̗?Ƃ͈قȂ?AAUDIT_COLUMN?Ɏw?肵?Ă???CUSTOMER_ID??SELECT?傪??v???Ȃ????߁A?č??Ώۂ??珜?O?????SQL???B
SELECT CUSTOMER_NAME FROM CUSTOMER_CUSTOMER_MAIN WHERE PREF_CODE = 12
???̏ꍇ?A?J??????CUSTOMER_ID?ł???A?č??ΏۂƂȂ?B
???t?@?C???O???C???č????O?̊m?F
?@?ʏ?̃f?[?^?x?[?X?č??Ɠ??l?Ƀt?@?C???O???C???č??ɂ?郍?O??Oracle9i?f?[?^?x?[?X??ɕۑ??????B?t?@?C???O???C???č??̏ꍇ?́ASYS.DBA_FGA_AUDIT_TRAIL?r???[?ɕۑ?????A???̃r???[???m?F???邱?ƂŊč??L?^???m?F???邱?Ƃ??ł???B
?@Oracle9i?f?[?^?x?[?X?̃f?[?^?x?[?X?č??@?\?̑?g???????ł??????낤???B?f?[?^?x?[?X?č??@?\?́A?f?[?^?x?[?X?̑召?ɊW?Ȃ??A?ۑ?????Ă???f?[?^?̏d?v???ɂ???ẮA?傫?Ȍ??ʂ???????̂ɂȂ邩??????Ȃ??i???????A?t?@?C???O???C???č??́AEnterprise Edition???C?Z???X???[?U?[???ΏۂƂȂ邱?ƂƁA?ʏ?̃f?[?^?x?[?X?č??Ŏ?????邱?Ƃ??????̂ŁA???p?????@??͔??ɏ??Ȃ????낤?j?B
?@???K?̓T?[?o?̏ꍇ?ł??ڋq???????\???l?????????Ă???ꍇ?́A?????????????Ă??悢????????Ȃ??B????ɁA?ڂ??????ɂ??ẮA?uOracle Technology Network Japan?v???Oracle?f?[?^?x?[?X?̃I?????C???}?j???A???Ȃǂ????邱?ƂŁA?ڍ????邾?낤?BOracle9i?̕??L???Z?L?????e?B?@?\?̒??ō???Љ???f?[?^?x?[?X?č??ɂ??Ă????????Ă??????ƂŁA?V?X?e???\?z?̍ۂɂ??????I??Oracle9i?f?[?^?x?[?X?????p????????????̂ƍl???Ă???B
?@????́AOracle9i?f?[?^?x?[?X?̒ʐM?????̈Í????@?\???Љ?????B
?M??Profile
??????ЃC???^?[?l?b?g???????????@??C???????B
?c?????i???̂??@?݂??????j
??w????ɎЉ?????w?сA???݂́AIT?R???T???^???g?Ƃ??āA???????B
?֘A?L??
Copyright © ITmedia, Inc. All Rights Reserved.
?A?C?e?B???f?B?A????̂??m?点
??IT eBook
RSS?ɂ???
?A?C?e?B???f?B?AID?ɂ???
???[???}?K?W???o?^
??IT?̃??[???}?K?W???́A ???????A???ׂĖ????ł??B???Ѓ??[???}?K?W???????w?ǂ????????B
ITmedia?̓A?C?e?B???f?B?A??????Ђ̓o?^???W?ł??B
???f?B?A?ꗗ | ????SNS | ?L???ē? | ???₢???킹 | ?v???C?o?V?[?|???V?[ | RSS | ?^?c??? | ?̗p??? | ??????