°¨»ç ±â´É Ȱµ¿ Á¦¾î¿¡ ´ëÇÑ ¼³¸íÀÇ ÀϺημ, ´ÙÀ½°ú °°Àº °£´ÜÇÑ ½Ã³ª¸®¿À¸¦ »ç¿ëÇÕ´Ï´Ù. newton »ç¿ëÀÚ´Â Å×À̺íÀ» ¿¬°áÇϰí ÀÛ¼ºÇÏ´Â testapp ÀÀ¿ëÇÁ·Î±×·¥À» ½ÇÇàÇÕ´Ï´Ù. ÀÌ¿Í µ¿ÀÏÇÑ ÀÀ¿ëÇÁ·Î±×·¥ÀÌ ¾Æ·¡ ¼³¸íÇÏ´Â °¢ ¿¹¿¡¼ »ç¿ëµË´Ï´Ù.
±Ø´ÜÀûÀÎ ¿¹¸¦ Ç¥½ÃÇÏ¸ç ½ÃÀÛÇÕ´Ï´Ù. ¸ðµç ¼º°ø ¹× ½ÇÆÐ °¨»ç À̺¥Æ®¸¦ °¨»çÇϵµ·Ï °áÁ¤ÇßÀ¸¹Ç·Î, ´ÙÀ½°ú °°Àº ¹æ¹ýÀ¸·Î °¨»ç ±â´ÉÀ» ±¸¼ºÇÕ´Ï´Ù.
db2audit configure scope all status both
ÁÖ: | À̰ÍÀº °¡´ÉÇÑ ¸ðµç °¨»ç °¡´É À̺¥Æ®¿¡ ´ëÇÑ °¨»ç ·¹Äڵ带 ÀÛ¼ºÇÕ´Ï´Ù. °á°úÀûÀ¸·Î, ¸¹Àº ·¹Äڵ尡 °¨»ç ·Î±×¿¡ ¾²¿©Áö¸ç À̰ÍÀº µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ÀÇ ¼º´ÉÀ» ÀúÇϽÃŵ´Ï´Ù. ÀÌ·¯ÇÑ ±Ø´ÜÀûÀÎ °æ¿ì´Â ½Ã¹ü ¿ëµµ·Î¸¸ Ç¥½ÃµÇ¸ç, À§¿¡¼ Ç¥½ÃÇÑ ¸í·ÉÀÌ ÀÖ´Â °¨»ç ±â´ÉÀ» ±¸¼ºÇϵµ·Ï ±ÇÀåÇÏÁö ¾Ê½À´Ï´Ù. |
ÀÌ ±¸¼º("db2audit start" »ç¿ë)À» »ç¿ëÇÏ¿© °¨»ç ±â´ÉÀ» ½ÃÀÛÇÑ ´ÙÀ½ testapp ÀÀ¿ëÇÁ·Î±×·¥À» ½ÇÇàÇϸé, ´ÙÀ½ ·¹Äڵ尡 »ý¼ºµÇ¾î °¨»ç ·Î±×¿¡ À§Ä¡ÇÕ´Ï´Ù. ·Î±×¿¡¼ °¨»ç ·¹Äڵ带 ¹ßÃéÇÏ¿©, ÀÀ¿ëÇÁ·Î±×·¥ÀÌ ¼öÇàÇÑ µÎ °¡Áö Á¶Ä¡¿¡ ´ëÇØ »ý¼ºµÈ ´ÙÀ½°ú °°Àº ·¹Äڵ带 º¼ ¼ö ÀÖ½À´Ï´Ù.
timestamp=1998-06-24-08.42.10.555345;category=CONTEXT; audit event=CONNECT;event correlator=2;database=FOO; application id=*LOCAL.newton.980624124210; application name=testapp; timestamp=1998-06-24-08.42.10.944374;category=VALIDATE; audit event=AUTHENTICATION;event correlator=2;event status=0; database=FOO;userid=boss;authid=BOSS;execution id=newton; application id=*LOCAL.newton.980624124210;application name=testapp; auth type=SERVER; timestamp=1998-06-24-08.42.11.527490;category=VALIDATE; audit event=CHECK_GROUP_MEMBERSHIP;event correlator=2; event status=-1092;database=FOO;userid=boss;authid=BOSS; execution id=newton;application id=*LOCAL.newton.980624124210; application name=testapp;auth type=SERVER; timestamp=1998-06-24-08.42.11.561187;category=VALIDATE; audit event=CHECK_GROUP_MEMBERSHIP;event correlator=2; event status=-1092;database=FOO;userid=boss;authid=BOSS; execution id=newton;application id=*LOCAL.newton.980624124210; application name=testapp;auth type=SERVER; timestamp=1998-06-24-08.42.11.594620;category=VALIDATE; audit event=CHECK_GROUP_MEMBERSHIP;event correlator=2; event status=-1092;database=FOO;userid=boss;authid=BOSS; execution id=newton;application id=*LOCAL.newton.980624124210; application name=testapp;auth type=SERVER; timestamp=1998-06-24-08.42.11.622984;category=CHECKING; audit event=CHECKING_OBJECT;event correlator=2;event status=0; database=FOO;userid=boss;authid=BOSS; application id=*LOCAL.newton.980624124210;application name=testapp; object name=FOO;object type=DATABASE;access approval reason=DATABASE; access attempted=CONNECT; timestamp=1998-06-24-08.42.11.801554;category=CONTEXT; audit event=COMMIT;event correlator=2;database=FOO;userid=boss; authid=BOSS;application id=*LOCAL.newton.980624124210; application name=testapp; timestamp=1998-06-24-08.42.41.450975;category=CHECKING; audit event=CHECKING_OBJECT;event correlator=2;event status=0; database=FOO;userid=boss;authid=BOSS; application id=*LOCAL.newton.980624124210;application name=testapp; package schema=NULLID;package name=SQLC28A1;object schema=NULLID; object name=SQLC28A1;object type=PACKAGE; access approval reason=OBJECT;access attempted=EXECUTE;
timestamp=1998-06-24-08.42.41.476840;category=CONTEXT; audit event=EXECUTE_IMMEDIATE;event correlator=3;database=FOO; userid=boss;authid=BOSS;application id=*LOCAL.newton.980624124210; application name=testapp;package schema=NULLID;package name=SQLC28A1; package section=203;text=create table audit(c1 char(10), c2 integer); timestamp=1998-06-24-08.42.41.539692;category=CHECKING; audit event=CHECKING_OBJECT;event correlator=3;event status=0; database=FOO;userid=boss;authid=BOSS; application id=*LOCAL.newton.980624124210;application name=testapp; package schema=NULLID;package name=SQLC28A1;package section=0; object schema=BOSS;object name=AUDIT;object type=TABLE; access approval reason=DATABASE;access attempted=CREATE; timestamp=1998-06-24-08.42.41.570876;category=CHECKING; audit event=CHECKING_OBJECT;event correlator=3;event status=0; database=FOO;userid=boss;authid=BOSS; application id=*LOCAL.newton.980624124210;application name=testapp; package schema=NULLID;package name=SQLC28A1;package section=0; object name=BOSS;object type=SCHEMA;access approval reason=DATABASE; access attempted=CREATE; timestamp=1998-06-24-08.42.41.957524;category=OBJMAINT; audit event=CREATE_OBJECT;event correlator=3;event status=0; database=FOO;userid=boss;authid=BOSS; application id=*LOCAL.newton.980624124210;application name=testapp; package schema=NULLID;package name=SQLC28A1;package section=0; object schema=BOSS;object name=AUDIT;object type=TABLE; timestamp=1998-06-24-08.42.42.018900;category=CONTEXT;audit event=COMMIT; event correlator=3;database=FOO;userid=boss;authid=BOSS; application id=*LOCAL.newton.980624124210;application name=testapp; package schema=NULLID;package name=SQLC28A1;
ÀÌ¿Í °°ÀÌ, °¡´ÉÇÑ ¸ðµç °¨»ç À̺¥Æ® ¹× À¯ÇüÀÇ °¨»ç¸¦ ¿äûÇÏ´Â °¨»ç ±¸¼º¿¡¼ »ý¼ºµÈ Áß¿äÇÑ ¸î °³ÀÇ °¨»ç ·¹Äڵ尡 ÀÖ½À´Ï´Ù.
´ëºÎºÐÀÇ °æ¿ì, °¨»çÇÏ·Á´Â À̺¥Æ®¿¡ ´ëÇØ ´õ Á¦Çѵǰųª ÃÊÁ¡ÀÌ ÀÖ´Â ºäÀÇ °¨»ç ±â´ÉÀ» ±¸¼ºÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, ½ÇÆÐÇÑ À̺¥Æ®¸¸À» °¨»çÇÏ·Á¸é, °¨»ç ±â´ÉÀº ´ÙÀ½°ú °°ÀÌ ±¸¼ºµÉ ¼ö ÀÖ½À´Ï´Ù.
db2audit configure scope audit,checking,objmaint,secmaint,sysadmin, validate status failure
ÁÖ: | ÀÌ ±¸¼ºÀº Ãʱ⠰¨»ç ±¸¼ºÀ̰ųª °¨»ç ±¸¼ºÀÌ Àç¼³Á¤µÉ ¶§ ¹ß»ýÇÏ´Â ±¸¼ºÀÔ´Ï´Ù. |
ÀÌ ±¸¼ºÀ» »ç¿ëÇÏ¿© °¨»ç ±â´ÉÀ» ½ÃÀÛÇÑ ´ÙÀ½ testapp ÀÀ¿ëÇÁ·Î±×·¥À» ½ÇÇàÇϸé, ´ÙÀ½ ·¹Äڵ尡 »ý¼ºµÇ¾î °¨»ç ·Î±×¿¡ À§Ä¡ÇÕ´Ï´Ù(±×¸®°í ÀÌÀü¿¡ testapp¸¦ ½ÇÇàÇÏÁö ¾ÊÀº °ÍÀ¸·Î °¡Á¤ÇÕ´Ï´Ù). ·Î±×¿¡¼ °¨»ç ·¹Äڵ带 ¹ßÃéÇÏ¿©, ÀÀ¿ëÇÁ·Î±×·¥ÀÌ ¼öÇàÇÑ µÎ °¡Áö Á¶Ä¡¿¡ ´ëÇØ »ý¼ºµÈ ´ÙÀ½°ú °°Àº ·¹Äڵ带 º¼ ¼ö ÀÖ½À´Ï´Ù.
timestamp=1998-06-24-08.42.11.527490;category=VALIDATE; audit event=CHECK_GROUP_MEMBERSHIP;event correlator=2; event status=-1092;database=FOO;userid=boss;authid=BOSS; execution id=newton;application id=*LOCAL.newton.980624124210; application name=testapp;auth type=SERVER; timestamp=1998-06-24-08.42.11.561187;category=VALIDATE; audit event=CHECK_GROUP_MEMBERSHIP;event correlator=2; event status=-1092;database=FOO;userid=boss;authid=BOSS; execution id=newton;application id=*LOCAL.newton.980624124210; application name=testapp;auth type=SERVER; timestamp=1998-06-24-08.42.11.594620;category=VALIDATE; audit event=CHECK_GROUP_MEMBERSHIP;event correlator=2; event status=-1092;database=FOO;userid=boss;authid=BOSS; execution id=newton;application id=*LOCAL.newton.980624124210; application name=testapp;auth type=SERVER;
(none)
À̺¥Æ® ½Ãµµ°¡ ½ÇÆÐÇÑ °æ¿ì¿¡¸¸ °¡´ÉÇÑ ¸ðµç °¨»ç À̺¥Æ®(CONTEXT Á¦¿Ü)ÀÇ °¨»ç¸¦ ¿äûÇÏ´Â °¨»ç ±¸¼º¿¡¼ »ý¼ºµÈ ÈξÀ ´õ ÀûÀº °¨»ç ·¹Äڵ尡 ÀÖ½À´Ï´Ù. »ç¿ëÀÚ´Â °¨»ç ±¸¼ºÀ» º¯°æÇÏ¿© »ý¼ºµÈ °¨»ç ·¹ÄÚµåÀÇ À¯Çü ¹× Ư¼ºÀ» Á¦¾îÇÒ ¼ö ÀÖ½À´Ï´Ù.
°¨»ç ±â´ÉÀº °¨»çÇÏ·Á´Â °¨»ç ·¹Äڵ尡 ¿ÀºêÁ§Æ®¿¡ ´ëÇØ ¼º°øÀûÀ¸·Î Ư±ÇÀÌ ±ÇÇÑ ºÎ¿©µÆÀ» ¶§ °¨»ç ·¹Äڵ带 ÀÛ¼ºÇÒ ¼ö ÀÖ°Ô ÇÕ´Ï´Ù. ÀÌ °æ¿ì, ´ÙÀ½°ú °°ÀÌ °¨»ç ±â´ÉÀ» ±¸¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.
db2audit configure scope checking status success
ÀÌ ±¸¼ºÀ» »ç¿ëÇÏ¿© °¨»ç ±â´ÉÀ» ½ÃÀÛÇÑ ´ÙÀ½ testapp ÀÀ¿ëÇÁ·Î±×·¥À» ½ÇÇàÇϸé, ´ÙÀ½ ·¹Äڵ尡 »ý¼ºµÇ¾î °¨»ç ·Î±×¿¡ À§Ä¡ÇÕ´Ï´Ù(±×¸®°í ÀÌÀü¿¡ testapp¸¦ ½ÇÇàÇÏÁö ¾ÊÀº °ÍÀ¸·Î °¡Á¤ÇÕ´Ï´Ù). ·Î±×¿¡¼ °¨»ç ·¹Äڵ带 ¹ßÃéÇÏ¿©, ÀÀ¿ëÇÁ·Î±×·¥ÀÌ ¼öÇàÇÑ µÎ °¡Áö Á¶Ä¡¿¡ ´ëÇØ »ý¼ºµÈ ´ÙÀ½°ú °°Àº ·¹Äڵ带 º¼ ¼ö ÀÖ½À´Ï´Ù.
timestamp=1998-06-24-08.42.11.622984;category=CHECKING; audit event=CHECKING_OBJECT;event correlator=2;event status=0; database=FOO;userid=boss;authid=BOSS; timestamp=1998-06-24-08.42.41.450975;category=CHECKING; audit event=CHECKING_OBJECT;event correlator=2;event status=0; database=FOO;userid=boss;authid=BOSS; application id=*LOCAL.newton.980624124210;application name=testapp; package schema=NULLID;package name=SQLC28A1;object schema=NULLID; object name=SQLC28A1;object type=PACKAGE; access approval reason=OBJECT;access attempted=EXECUTE; timestamp=1998-06-24-08.42.41.539692;category=CHECKING; audit event=CHECKING_OBJECT;event correlator=3;event status=0; database=FOO;userid=boss;authid=BOSS; application id=*LOCAL.newton.980624124210;application name=testapp; package schema=NULLID;package name=SQLC28A1;package section=0; object schema=BOSS;object name=AUDIT;object type=TABLE; access approval reason=DATABASE;access attempted=CREATE; timestamp=1998-06-24-08.42.41.570876;category=CHECKING; audit event=CHECKING_OBJECT;event correlator=3;event status=0; database=FOO;userid=boss;authid=BOSS; application id=*LOCAL.newton.980624124210;application name=testapp; package schema=NULLID;package name=SQLC28A1;package section=0; object name=BOSS;object type=SCHEMA;access approval reason=DATABASE; access attempted=CREATE;
(none)