With particular because of Pete Bryan, Principal Safety Analysis Supervisor, Microsoft Safety.
The SQL injection assault stays one of many crucial assaults within the OWASP Prime 10, and it entails injecting a SQL question by way of the enter information discipline into an internet software with out enter validation. In accordance with Microsoft Digital Protection Report 2022, 67 p.c of internet software exploits embrace SQL injections.
Azure Internet Utility Firewall (Azure WAF) gives centralized safety of your internet functions from exploits and vulnerabilities. It protects in opposition to OWASP Prime 10 assaults, bot assaults, software layer Distributed Denial of Service (DDoS) assaults, and different internet assaults.
Azure WAF detects SQL injection assaults and blocks them by default. In sure cases, this may very well be a false constructive that requires investigation and creation of Azure WAF exclusions. To finish a profitable investigation, full context concerning the assault is required and a course of that guides you thru the investigation is required.
We’re happy to announce a brand new Azure WAF guided investigation to tune WAF coverage Pocket book in preview. It guides you thru an investigation expertise to know the Azure WAF incidents in Microsoft Sentinel, determine false positives, and mechanically apply exclusions to WAF guidelines to deal with the false positives. This Pocket book means that you can perceive the WAF alert and pivot on key entities of the WAF occasion such because the request URI, shopper IP, hostname, and correlate with Menace Intelligence feeds to get a holistic view of the assault floor.
Azure WAF investigations powered by Microsoft Sentinel
Azure WAF is deeply built-in with Microsoft Sentinel, Microsoft’s Safety Data and Occasion Administration (SIEM) answer. Utilizing the prevailing Azure WAF information connector, WAF logs are ingested and later analyzed for quite a lot of internet software assaults and highly effective visualizations pivoting on the total assault sample are introduced to you. This Pocket book is constructed utilizing Microsoft Menace Intelligence Middle’s MSTICpy packages. With this Pocket book, you’ll be able to entry wealthy historic contextual info utilizing Microsoft Sentinel’s capabilities like incident era, entity graph, and menace intelligence correlation, at the side of Azure WAF’s SQL injection detections primarily based on OWASP guidelines and Microsoft Menace Intelligence guidelines.
Automated investigation and mitigation of internet software assaults
Our new Azure WAF guided investigation to tune WAF coverage Pocket book gives an automatic guided investigation for triaging Sentinel incidents triggered by Azure WAF SQL injection guidelines.
The answer contains the next parts:
- Azure WAF information connector in Microsoft Sentinel.
- Microsoft Sentinel incidents which are generated as a result of SQL injection assault detected by the Microsoft Sentinel analytic guidelines.
- Azure WAF Pocket book that helps examine Azure WAF logs and mechanically applies WAF exclusions to the WAF coverage.
A high-level diagram explaining the information movement is given beneath:
Allow us to have a look at two use case situations for utilizing this Pocket book:
Understanding the assault panorama when there’s a true constructive
Utilizing the Pocket book, you’ll be able to pivot on varied assault artifacts equivalent to IP, URL, or area menace intelligence, and perceive the entity graph. This Pocket book retrieves the WAF SQLi rule that generated the detection and appears up associated SQLi rule occasions inside the pre-selected time. Based mostly on the above particulars, if you happen to determine that the SQL injection assault is legitimate then you’ll be able to replace the incident severity and precedence. On this situation, the net software stays protected by Azure WAF.
Perceive the assault sample and create exclusions if there is a false constructive
Utilizing the Pocket book, you’ll be able to pivot on varied assault artifacts equivalent to IP, URL, or area menace intelligence, and perceive the entity graph. This Pocket book retrieves the WAF SQLi rule that generated the detection and appears up associated rule occasions. It additionally retrieves uncooked WAF logs to know the relations between the request URI, shopper Ips, hostname entities and means that you can dynamically entry the OWASP rule set in GitHub to know the rule match sample. Based mostly on the investigations, if you happen to determine this incident is a false constructive, the method to mechanically create granular exclusions is introduced to you and the exclusions are utilized to the Azure WAF coverage utilizing Azure WAF APIs.
The next personas would profit from this Pocket book:
Persona: Developer at SomeUnionFlight.com
Understanding SQL injection detection logic
Chris is a developer at SomeUnionFlight.com. His firm hosts a web site for customers to seek for flights and make flight reservations. They’ve hosted their web site behind WAF with Azure Entrance Door (AFD) the place AFD accepts person requests to go looking their web site. SomeUnionFlight.com has an SQL backend the place they retailer flight info. He notices that when customers attempt to entry the web site, their entry is getting blocked as a result of the URL has “Union” key phrase which is triggering the SQL injection rule. This detection is taken into account as a false constructive as a result of the “Union” key phrase is used to say a web site identify and never an SQL injection assault. He would really like an investigation expertise that helps him perceive tips on how to analyze this detection utilizing Microsoft Sentinel and decide if it’s a false constructive. He would additionally wish to mechanically create exclusions for false positives for the URL with out having to disable all the rule.
Persona: SecOps analyst at Contoso.com
Understanding collateral assault vectors
Ashley is a Safety Operations analyst at Contoso.com. Her firm has bought each Azure WAF and Microsoft Sentinel. She oversees analyzing WAF logs and figuring out assault patterns. She wish to perceive if the shopper IP or the request URI related to the WAF rule that triggered the SQL injection are Indicators of Compromise (IoC). By understanding associated Menace Intelligence Indicators of Compromises, she will be able to forestall future assaults on her group.
Get began at the moment
SQL injection assaults are getting extra prevalent by the day and Azure WAF protects internet functions from these assaults. To allow a high-quality investigation expertise for Azure WAF prospects, we’ve created this new Azure WAF guided investigation Pocket book that allows you rapidly perceive full assault floor and take actions on the incidents. You may observe our step-by-step directions to discover ways to use the Pocket book.
This new Azure WAF Pocket book will be present in Microsoft Sentinel underneath the Notebooks within the Menace Administration part.
