
ãã»ãã¥ãããå¹³æ29幎床ç§ååŸå2ã®è§£èª¬ïŒæ å ±ã»ãã¥ãªãã£ãããžã¡ã³ã詊éš, SG, ç§ç®BïŒ
ãã®Noteã§ã¯ãæ å ±ã»ãã¥ãªãã£ãããžã¡ã³ã詊éšïŒSGïŒãå¹³æ29幎床ç§ç§ç®Bå2ã解説ããŸãã
ãã¹ã¯ãŒãã¯ã©ãã¯æ»æã3çš®ã絡ã¿ãŸãããæ»æã®æå£ãšå¯ŸçãåŠã¹ãŸããæè¡çã«ã¯ãã¿ã€ã ã¢ãŠããã¯SGã§ã¯æ°ããç¥èãããSCãDBã§ã¯èŠãã®ã§ä»åŸã®ããã«èŠããŸãã

èšå2(2)bããŠã§ã蚺æä»æ§ãã¯ãè³æãèŠãããšãªããã°ãªããªãé£ããã®ã§ãããæ¶å»æ³ã§åããŸããã倱ç¹ããŠãçæã§ã¯ãªãã§ãã
ãã ãæãè¿ãã°ãâã¬ã€ãã©ã€ã³ã£ãŠå顿ã«ç¹°ãè¿ãç»å Žããããªãâãšãä»åŸãŸãå¥ã®ããŒãžãåºããããããŸããã
ãã®Noteã®æåŸã§ã¯ããSGã«ç»å ŽãããïŒã€ã®ã¬ã€ãã©ã€ã³/仿§ãããŸãšããŸãããèŠæãæœåºããã®ã§ãä»åŸâ䌌ãåé¡ã«ç©ãããããªãâæ¹ã¯æ¯éåèã«ããŠäžããã
ãã®Noteã«ã¯ãç§ãITå°éåŠæ ¡ã§ææ¥ããããšãåºã«äœæããŠããŸããå°éåŠçã¯æŽã«äžäœã®FE, APãç®æããŸããSGã¯ééç¹ã«éããŸãããæèãé«ãæã£ãŠãåæ Œä»¥äžã®åç²ãåŸãŠæ¬²ãããšæã解説ãäœããŸããã
ããã§ã¯å§ããŸãããïŒ
ç§ã®Noteã¯500èšäºä»¥äžãããŸãïŒ2025/11/30ïŒã
SGç§ç®A/ååã解説äœããŸããã
ïŒå
šNoteãžã®ãªã³ã¯ïŒSGïŒ
èšå1(1) | 確å®ãšãã·ãªè§£ç
æ£çã¯ãã€, ãªã
ã€ïŒå
ç«¥çšPWDãæ°å4æ¡ããè±æ°èšå·8æåã«å€æŽ
ãªïŒã¢ã«ãŠã³ãã®ããã¯æéã1åéãã60åéã«å€æŽ
äžç·â ããã«ãŒããã©ãŒã¹æ»æã®ãªã¹ã¯ãäœæžããããã«èªèšŒæ©èœã®ä»æ§ã倿ŽãããŠãèšåæãWãµãŒãã¹ã®ä»æ§æ¡ããæŽã«æ¹åããæšã
èªèšŒïŒïŒãã°ã€ã³ïŒãžã®ãã«ãŒããã©ãŒã¹æ»æïŒïŒPWDã«ããããæååã詊ãïŒã®æç«ãäœæžããã話ãïŒãIãã¹ããã¹ã¯ãŒãã¯ã©ãã¯ïŒçš®ã®Note
å³1ãWãµãŒãã¹ã®ä»æ§æ¡ãã®ãèªèšŒæ©èœãã«å±ãªãã®ãããŸããã
å³1-2-(1)ãæ°å€4æ¡ã®å
ç«¥çšãã¹ã¯ãŒããã
éžæè¢ã€ã§ãæ°å4æ¡ããè±æ°èšå·8æå以äžã«å€æŽãã§ããã«ãŒããã©ãŒã¹æ»æã¯æç«ãã«ãããªããŸããå
ç«¥ã¯å
¥åã倧å€ã§ããâŠã
å顿ãèªãã æç¹ã§"4æ¡ãœã£ã¡ã¯å±ãªãã§ãã"ãšâå°ãïŒé·æåé¡ãèªãïŒã€ã®ãã¯ããã¯NoteïŒïŒïŒïŒïŒ
ããš1ã€ãåéžæè¢ãèŠãªããæ±ºããŸãã
ã¢ïŒPWDã®å ¥åå 容ãåžžã«é衚瀺ã«ããã
â¡Ãã
é衚瀺ã«ãããããå ¥åã¯ã§ããã®ã§æ»æã¯é²ããŸããããŠïŒä¿è·è çšPWDãè±æ°èšå·8æå以äžããæ°å9æ¡ã«å€æŽã
â¡Ãã
æ¡ã1æ¡å¢ããŠããæåçš®é¡ãå°ãªããªã£ãã®ã§ãæ»æãæç«ãæãæ¹åããªããšïŒã¢ã«ãŠã³ãããã¯ããéŸå€ãã5åãã8åã«å€æŽã
â¡Ãã
倱æã§ããåæ°ãå¢ããŠããã®ã§ãã¡ããªïŒã¢ã«ãŠã³ãããã¯ããæéãã1åéãã60åéã«å€æŽã
â¡â³ã
1åã§ããã¯è§£é€ããããååºŠæ»æã§ãããªããŠãå®è³ªé£ç¶ã§æ»æãç¶ããã®ãšåãã60åéãªããæ»æè ã諊ãã/管çè ã調æ»ããŠæ°ã¥ãããã
ãªãäžçªãã·ã§ãããå人çã«ã¯ããã¯ã¡ãã£ãšèšããªãããªããšã
èšå1(2) | çéãªã»ãã¥ãªãã£å¯Ÿçãã¡
æ£çã¯ãã«ïŒãã°ã€ã³ãžã¿ã€ã ã¢ãŠãã®å°å ¥ïŒã
ãã¿ã€ã ã¢ãŠãããšã¯ãâæéåãâã®ããšãäŸãã°ãäžå®æéæäœãªãã£ããèªåã§ãã°ã¢ãŠãããããäžå®æééçžæããè¿äºããªããã°åŠçãäžæ¢ããããããã¯ãŒã¯ã§ã®ãµãŒãã®å¿çãããŒã¿ããŒã¹ã®åŠçå¿çãªã©ãïŒãDBããããããã¯ã®Note
WebããŒãžãYoutubeã§ããã£ã€âããããâããŠãã®èŠãããšããããã§ããã
äžç·â¡ã¯ãå ±çšPCã«ãããé²èЧãªã¹ã¯ãäœæžããæ©èœã远å ããäžç·â¡åã«ãå ç«¥ã¯å ±çšPC@峿žé€š/åŠæ ¡ã䜿ãããã詊éšçµæ/æçžŸãä»ã®äººã«èŠãããã ãããã£ãŠè©±ã
ä»äººã«é²èЧããããªã¹ã¯ã«æ³šç®ããŠãéžæè¢ãèŠããšãã«ããã°ã€ã³ãã¿ã€ã ã¢ãŠããããæ©èœããè¯ãã§ããã
埩ç¿ãªã®ã§ãäžæ£è§£ã®éžæè¢ãã»ãã¥ãªãã£å¯ŸçãšããŠçè§£ããŸãã
ã¢ïŒã¢ã«ãŠã³ãããã¯ãå©çšè ãè§£é€ããæ©èœ
ã€ãééããç¶ããŠããã¯ãããããšã¯ããã®ã§ãè§£é€ããæ©èœããã£ãŠãè¯ãã§ãããã§ã1æéåŸ ãŠã°è§£é€ããããã远å ããªããŠãè¯ãããªããšããã€ïŒå®æçãªPWD倿Žãä¿ãæ©èœ
äžæ£ãã°ã€ã³ã®é²æ¢ã«ãªããŸããã
å人çã«ã¯å šç¶éãPWDã«ãããšå¿ããã®ã§ãèªå°Ÿã«æ°å€ãèšå·ã远å ããã ãã«ããŠãŸããPWDã¯ãããã·ã¥å€ãã§ä¿ç®¡ãããã®ã§ã¡ãã£ãšå€æŽããã ãã§ãå šç¶éãããã·ã¥å€ã«ãªãã®ã§åé¡ãããŸããããŠïŒPWD匷床ããã§ãã¯ããæ©èœ
è²ããªæåçš®ïŒè±å€§å°, æ°å, èšå·ïŒã䜿ã£ãŠããããæåæ°ã¯é·ãããªã©ãåèªã䜿ã£ãŠããªãããªã©ãïŒãIãã¹ããã¹ã¯ãŒãã¯ã©ãã¯ïŒçš®ã®Note
ããã¹ã¯ãŒãããªã·ãŒãã«ãŠãPWDç»é²æã«æ¡ä»¶ãèšããã®ããïŒæåæ°, 倧æåå°æåã»æ°åèšå·ãå«ãããªã©ïŒããšïŒãã¹ã¯ãŒããå¿ããæã«äœ¿ã"ç§å¯ã®è³ªå"æ©èœã
å°åŠæ ¡ã®ååããããã®ååãªã©ãèšå®ããŸãããPWDããã¯æå³ããã£ãŠãæ¬äººããç¥ããªãããªæ å ±ããªïŒãã«ãŠã§ã¢æ€ç¥æ©èœ
ãŠã€ã«ã¹å¯Ÿçãœããã®ãããªãäžè¬çãªã®ã¯ã·ã°ããã£åã«ãããã¿ãŒã³ãããã³ã°æ¹åŒãã«ïŒãã°ã€ã³ãã¿ã€ã ã¢ãŠããããæ©èœ
â¡ãã
ãã°ã€ã³ãã£ã±ãã§PCããç«ã¡å»ããä»äººãPCã䜿ãå§ãããèŠããã¡ãããŸãã
èšå2(1)a | Webã¢ããªç³»ã®æ»æïŒïŒÎ±
æ£çã¯ããŠïŒèœåç, ååçïŒã
ååçãšã¯âåã身âãä»ããã®åãããã§åããæç€ºã«åŸããªã©ã
èœåçãšã¯âèªåããåãâãèªåã§èããŠææ¡/è¡åãããªã©ã
衚1ã®1ïœ4ã¯ãWebãµã€ããžå ¥åã§ããæ©èœãããå Žåã«ãå ¥åæ©èœãæªçšããæ»æã§ããïŒãIãã¹ãWebç³»æ»æïŒçš®ã®Note
ãSQLã€ã³ãžã§ã¯ã·ã§ã³ãã¯ãããŒã¿ããŒã¹ãäžæ£å©çšããæ»æã
æ»æè ãå ¥åããŠãµãŒããäžæ£ã«åããã®ã§ãèœåçã

ãã¯ãã¹ãµã€ãã¹ã¯ãªããã£ã³ã°ïŒXSSïŒãã¯ãWebãµã€ãã«æªæã®ããã¹ã¯ãªãããåã蟌ãã§ãé²èЧè ã®èšªåæã«å®è¡ããåœãµã€ãã«èªå°ããæ»æã
æ»æè ä»èŸŒãã§åŸ ã£ãŠãŸããæ»æè ãåå©çšè ã«ïŒèœåçã«ïŒæ»æã¯ããŠãŸãããå©çšè ãWebãµã€ãã蚪ããæã«çºçããã®ã§ãååçã
倪åã«ããçšèªãšæå£ïŒããŒã¯ãŒãïŒã§èŠããŠãã ãããã
XSSïŒã¯ãã¹ãµã€ãã¹ã¯ãªããã£ã³ã°ïŒïŒWebãµã€ãã«æªæã®ããã¹ã¯ãªãããåã蟌ãã§ãé²èЧè ã®èšªåæã«å®è¡ããåœãµã€ãã«èªå°ãã
XSRFïŒCSRF, ã¯ãã¹ãµã€ããªã¯ãšã¹ããã©ãŒãžã§ãªïŒïŒWebãµã€ãã«æªæã®ããã¹ã¯ãªãããåã蟌ãã§ãé²èЧè ãæ°ã¥ããªããã¡ã«å¥ãµã€ãã§æå³ããªãæäœããã
SQLã€ã³ãžã§ã¯ã·ã§ã³ïŒããŒã¿ããŒã¹ãäžæ£å©çšãã
BoFïŒãããã¡ãªãŒããŒãããŒïŒïŒæ³å®å€ã®é·å€§ãªå ¥åãããŠãããã¡ãããµããããæ»æè ã®çšæããããã°ã©ã ãå®è¡ããããªã©èª€åäœããã
ä»ã«ããããã£ã¬ã¯ããªãã©ããŒãµã«æ»æããOSã³ãã³ãã€ã³ãžã§ã¯ã·ã§ã³ããèŠããŸããIãã¹ã¬ãã«ã§ããïŒãIãã¹ãWebç³»æ»æïŒçš®ã®Note
èšå2(2)b | æ¶å»æ³ã§äžçªãã·ãªè§£
æ£çã¯ãã¢ïŒã¯ããŒã©ãžã®èæ§ïŒã
ãã¯ããŒã©ããšã¯ãWebããŒãžãå·¡åããæ å ±åéããã°ã©ã ãäŸãã°googleãªã©ã®æ€çŽ¢ãšã³ãžã³ãWebãµã€ãã®ããŒã¿ããŒã¹ãäœæ/æŽæ°ããããã«ãã¯ããŒã©ãåŸåŸãããŠãŸãã
衚1ãèŠããšã空æ¬bãã«æ»æåãå ¥ããããªã®ãã€ãžã¯ã«ã§ãããééã£ãŠã仿¹ãªãããªããšã
æ£è§£äžçºåŒãã¯ããã·ã€ã®ã§ãä»éžæè¢ãæ€èšããŠãâã¯ããŒã©ããã·ããªãâçšåºŠã®ç²ŸåºŠã§ãã衚1ã空æ¬bãã¯å¯çšæ§ã«é¢ããç¹ã«ã泚æã
ã»ãã·ã§ã³ç®¡çã®äžåïŒHTTPéä¿¡ã¯ãã»ãã·ã§ã³IDãã£ãŠæŽççªå·ã§ç®¡çãããŸããäŸãã°æ»æè ã«ã»ãã·ã§ã³IDãçèŽããããšããªãããŸãã¢ã¯ã»ã¹ãã§ããŸãïŒã»ãã·ã§ã³ãã€ãžã£ãã¯ïŒãä»ã«ããã»ãã·ã§ã³IDåºå®åæ»æãããããïŒãSCãã»ãã¹ãã«ã§ã73çš®ã®æ»æNoteïŒã»ãã·ã§ã³ç³»ïŒ
â¡ãªãããŸãã®é¡ãªã®ã§ãæ©å¯æ§ã絡ã¿ããªããã»ãã·ã§ã³ç®¡çäžåã§éä¿¡/ãµãŒãã¹ãäžæããããªãã®ãå¯çšæ§ãšè§£éãè¥å¹²ã§ããŸãããã¢ã¯ä¿çããšããŸããããã£ã¬ã¯ããªãã©ããŒãµã«ãïŒWebããŒãžã®ãªã³ã¯ãçšããã«ãçŽæ¥ãã¡ã€ã«ããã©ã«ããžã®ã¢ã¯ã»ã¹ã詊ã¿ãæ»æã
â¡Webãµã€ããžã®ã¢ã¯ã»ã¹ãªã®ã§ãæ©å¯æ§ã絡ã¿ãïŒãIãã¹ãWebç³»æ»æïŒçš®ã®Noteãã£ã¬ã¯ããªãªã¹ãã£ã³ã°ïŒWebãµãŒãã®ãã¡ã€ã«äžèЧãå ¥æããæ»æïŒè©³çްã¯éå»åéå ŽãããžïŒããã£ã¬ã¯ããªãã©ããŒãµã«æ»æãšäŒŒãŠãŸããããªã¹ãã£ã³ã°ïŒãªã¹ãããïŒã®æå³ã§èŠããã®ã¯ç°¡åããã
â¡ãã¡ã€ã«ã®äžèЧãªã®ã§ãæ©å¯æ§ã絡ã¿ãèªå¯å¶åŸ¡ã®äžå, æ¬ èœïŒãèªå¯ãã¯æäœæš©éãèªããããšãäŸãã°ãã¡ã€ã«ã®é²èЧã»ç·šéã»åé€ãªã©ããèªèšŒãã¯ãã°ã€ã³å¯åŠïŒID, PWDïŒããèªå¯ãã¯ãã°ã€ã³åŸã®æäœã®æš©éã®è©±ã
â¡ã¢ã¯ã»ã¹å¯åŠãªã®ã§ãæ©å¯æ§ã絡ã¿ã
ã¢ïŒã¯ããŒã©ãžã®èæ§ïŒãšã€ïŒã»ãã·ã§ã³ç®¡çïŒãæ®ããŸã§çµãããçžåœè¯ãã§ãããããšã¯ãâã¢ïŒã¯ããŒã©ãžã®èæ§ããªã=ã¢ã¯ã»ã¹æ°ã«åŒ±ãâ¡ä»å©çšè ã䜿ããªããªã=å¯çšæ§ã«åœ±é¿â¡è¡š1å¯èœæ§ãšäžèŽâãšæèã§ãããªãã
衚1ã§ã¯7çš®é¡ã§ããããè³æã§ã¯13çš®é¡ã§ããïŒpdfãã¡ã€ã«ïŒIPAå ¬åŒãµã€ãïŒãä»åã«ãããããã®ãåºããããããŸãããã
SGã§ã¯åºŠã â仿§æžââã¬ã€ãã©ã€ã³âãç»å ŽããŸãããã®å Žãã®å Žã§æ£è§£ã§ããŸãããè³æãå ¥æããŠçºããã¹ãã§ããèŠãããã¯ããŠãããä»åŸãå¥ã®é ãã§ããããããŸãããã
ãã®Noteã®æåŸã«âSGã«ç»å Žãã5åã®è³æâããŸãšããŸããã
èšå2(3) | å§èšå ãžã®ç£ç£/é£çµ¡
æ£çã¯ããŠïŒi, ii, iii, vïŒã
iïŒéçºäžã«ã»ãã¥ãªãã£è¿œå ãå¿
èŠãªå Žåãå§èšå
ã«ææ¡ãã
iiïŒåå§èšå
ãå«ããéçºäœå¶ããå§èšå
ã«èª¬æãã
iiiïŒã»ãã¥ãªãã£è©Šéšã®çµæããå§èšå
ã«çŽåãã
vïŒçŽååŸã®ã»ãã¥ãªãã£ãµããŒãã®æ¹æ³/è²»çšããå§èšå
ã«èª¬æãã
äžç·â¢å§èšä»æ§æžã«çã蟌ãã ä»ã®äºé ïŒè¡š1Web蚺æãšã¯å¥ïŒã®è©±ã
ä»ç€Ÿãžã®éçºå§èšã®è©±ãªã®ã§ãèªç€ŸããŒã¿ã®ç§å¯å¥çŽã»ããã°ã©ã ã®ã»ãã¥ãªãã£ãªã©ã®è©±ã ãããªããšæšå¯ã
ivã¯ãP瀟以å€ããåæ³šããä»äºã®ä»æ§æžãé瀺ããããªãã§ããããä»ã¯ãP瀟ãäŸé ŒäººãšããŠçµ¡ãã§ããã®ã§åŠ¥åœããªãšã
iïŒéçºäžã«ã»ãã¥ãªãã£è¿œå ãå¿ èŠãªå Žåãå§èšå Pç€Ÿã«ææ¡ãã
â¡ããåæã«è¿œå ãããŠãå°ãããããè¯ããããããææ¡ããŠæ¬²ããã§ããããiiïŒåå§èšå ãå«ããéçºäœå¶ããå§èšå P瀟ã«èª¬æãã
â¡ããäžè«ãã«åºããªãã¡ãããšç£ç£ããŠæ¬²ããããã©ãã«æäŒã£ãŠãããã®ã説æããŠæ¬²ããã§ããããiiiïŒã»ãã¥ãªãã£è©Šéšã®çµæããå§èšå P瀟ã«çŽåãã
â¡ãã詊éšçµæã¯å ±åããŠæ¬²ããã§ããivïŒä»ç€Ÿããåé ãã仿§æžããå§èšå P瀟ã«é瀺ãã
â¡ÃãP瀟é¢ä¿ã§ãããããŸã§ã®æš©å©ã¯ãªããvïŒçŽååŸã®ã»ãã¥ãªãã£ãµããŒãã®æ¹æ³/è²»çšããå§èšå P瀟ã«èª¬æãã
â¡ããã¢ãã¿ãŒãµãŒãã¹ã®èª¬æã¯æ¬²ããã§ãã
èšå3(1)c | å顿ãèã¥ãã§èŸ¿ã
æ£çã¯ãã€ïŒOSã³ãã³ãã€ã³ãžã§ã¯ã·ã§ã³ã®è匱æ§ãæ€åºãããïŒã
ã空æ¬cãã®è匱æ§ã¯ãèŠæ²»çã»ç²Ÿå¯æ€æ»ïŒåªå 床ïŒé«ïŒããšå€å®ããããŸããã
å顿ã蟿ã£ãŠè¡š1ã«å°éãããã§ãã
ãåªå 床ïŒé«ãã¯ã衚3ãããå±éºåºŠãâé«âãã
ãå±éºåºŠãâé«âãã¯ã衚2ããå±éºåºŠããé«ãã¯ãèœåçæ»æãã§ãæ©å¯æ§ãè匱æ§ã®è¢«å®³ãã«ã€ãªãããã®ã
衚1ã§å±éºåºŠãé«ãã¯ã2ã€ïŒSQLã€ã³ãžã§ã¯ã·ã§ã³, OSã³ãã³ãã€ã³ãžã§ã¯ã·ã§ã³ïŒããèœåçããªã®ã¯2ã€ãšãããæ©å¯æ§ãè匱æ§ã®è¢«å®³ãã2ã€ãšãã
衚1ã§ã¯1ã€ã«çµããŸããã§ããããéžæè¢ã«ããã®ã¯çæ¹ã ããã€ïŒOSã³ãã³ãã€ã³ãžã§ã¯ã·ã§ã³ïŒ
ä»éžæè¢ãèŠãŸãã
å±éºåºŠãé«ããèœåçæ»æããæ©å¯æ§ããè匱æ§ãããã€ã³ãã
çµå±ãå±éºåºŠã ãã§å
šãŠæ¶å»ã§ããã®ã§ç°¡åã§ããã
ã¢ïŒHTTPãããã€ã³ãžã§ã¯ã·ã§ã³
â¡è¡š1-6ãå±éºåºŠãäžããªã®ã§ÃããŠïŒXSRF
â¡è¡š1-3ãå±éºåºŠãäžããªã®ã§ÃããšïŒXSRFãšâæå³ããªããªãã€ã¬ã¯ãâ
â¡è¡š1-3ãå±éºåºŠãäžããªã®ã§Ãã
衚1-5ãå±éºåºŠãäžããªã®ã§ÃããªïŒè¢«å®³ã軜埮ãªè匱æ§
â¡è¡š2-äœãšåããå±éºåºŠãäœããªã®ã§Ããã«ïŒæ»ææåã®å¯èœæ§ãäœãè匱æ§
â¡è¡š2-äœãšåããå±éºåºŠãäœããªã®ã§Ãã
èšå3(2) | åãããæ¡ä»¶ã«çæ£é¢
æ£çã¯ããŠïŒæ å ±ã»ãã¥ãªãã£å§å¡äŒã«ãããæ¿èªïŒã
ã¡ãã£ãšçºæ³ãè§£ãæé ã«æ £ããå¿ èŠã§ãã
å顿ã®äœã«æ³šç®ããããããŒã¯ãŒãããç¹å®ããŸããèšåæã®ãPç€Ÿã®æ å ±ã»ãã¥ãªãã£ç®¡çèŠå®ããã¹ã«ãŒãããåã£æãããšããŸãã