312-39 · Question #137
Sam, a security analyst with INFOSOL INC., while monitoring and analyzing IIS logs, detected an event matching regex /\\w*((\%27)|(\'))((\%6F)|o|(\%4F))((\%72)|r|(\%52))/ix. What does this event log…
The correct answer is A. SQL Injection Attack. The regex pattern /\\w*((\%27)|(\’))((\%6F)|o|(\%4F))((\%72)|r|(\%52))/ix is designed to detect SQL injection attacks. The pattern looks for common SQL injection payloads which typically include an apostrophe or single quote character (' or %27 when URL-encoded) followed by a…
Question
Sam, a security analyst with INFOSOL INC., while monitoring and analyzing IIS logs, detected an event matching regex /\w*((%27)|(\’))((%6F)|o|(%4F))((%72)|r|(%52))/ix. What does this event log indicate?
Options
- ASQL Injection Attack
- BParameter Tampering Attack
- CXSS Attack
- DDirectory Traversal Attack
How the community answered
(20 responses)- A80% (16)
- B5% (1)
- C5% (1)
- D10% (2)
Explanation
The regex pattern /\w*((%27)|(\’))((%6F)|o|(%4F))((%72)|r|(%52))/ix is designed to detect SQL injection attacks. The pattern looks for common SQL injection payloads which typically include an apostrophe or single quote character (' or %27 when URL-encoded) followed by a logical operator OR (represented by o, %6F, O, %4F, r, %72, R, %52). SQL injection attacks involve inserting or “injecting” a SQL query via the input data from the client to the application. A successful SQL injection exploit can read sensitive data from the database, modify database data (Insert/Update/Delete), execute administration operations on the database (such as shutdown the DBMS), recover the content of a given file present on the DBMS file system, and in some cases, issue commands to the operating system. logs for security threats. Information about the regex pattern used for detecting SQL injection attacks can be found in various cybersecurity resources, including OWASP’s guide on Testing for SQL Injection1 and Microsoft’s documentation on IIS logging2. These resources explain how regex patterns are used to identify potential security threats in log files and the importance of monitoring logs for unusual patterns that may indicate an attack. librarydocuments/viewdocument?DocumentKey=001f5e09-88b4-4a9a-b310- 4c20578eecf9&CommunityKey=1ecf5f55-9545-44d6-b0f4-4e4a7f5f5e68&tab=librarydocuments
Topics
Community Discussion
No community discussion yet for this question.