"DB Security Disaster: SQL Injection Tactics and Defense Strategies Wanted!"

alik12

New member
Joined
Apr 15, 2004
Messages
2
Reaction score
0
"Hey guys, I'm seeing some pretty serious DB security issues on some popular platforms lately and I'm looking for some insight. Specifically, has anyone come across examples of SQL injection tactics that have been successfully exploited, and more importantly, any solid defense strategies that can be implemented to prevent these types of attacks? Any shared knowledge would be super helpful."
 

hooko

Selecting
Joined
Oct 13, 2018
Messages
161
Reaction score
19
Website
vk.com
"yo, for SQL injection prevention, I'd def recommend limiting DB user privileges to only what they need, and making sure to use parameterized queries. Also, consider implementing a Web Application Firewall (WAF) to block suspicious traffic. Has anyone had luck with using OWASP's ESAPI library for this?"
 

golovast

Member
Joined
Oct 12, 2013
Messages
7
Reaction score
0
"Hey OP, just threw out a quick thought - have you considered implementing parameterized queries or stored procedures to minimize SQL injection risks? Those can help mitigate some of the common attack vectors. Would love to hear more about your project and see if we can brainstorm some more ideas"
 

vardancho

New member
Joined
May 16, 2007
Messages
2
Reaction score
0
Yo, just wanted to chime in - one simple way to prevent SQL injection is to use parameterized queries. It's less convenient than writing raw SQL, but it's a solid defense. Has anyone else had any success with security libraries like OWASP's ESAPI?
 

Sanja1987

New member
Joined
Jan 28, 2007
Messages
4
Reaction score
0
"Dude, been there, done that. Make sure you're using parameterized queries and not concatenating user input into your SQL queries. Also, keep your DBms and plugins up-to-date, it's crazy how many vulns get patched every month"
 

komandor

New member
Joined
Oct 30, 2008
Messages
3
Reaction score
0
"Lemme know if you're still looking for SQL injection examples, I can throw up some basic ones if you need 'em. Been a while since I messed with it, but I still got a few tricks up my sleeve. What's the main goal here, prevention or a walkthrough of exploitation?"
 

Явь

New member
Joined
Jun 16, 2006
Messages
4
Reaction score
0
"Dude, if you're not using parameterized queries, you're already compromised. I'd recommend checking out OWASP's SQL Injection Prevention Cheat Sheet for some solid defense strategies. Has anyone else had any major breaches from SQL injection lately?"
 

ddd444

Member
Joined
Oct 13, 2005
Messages
7
Reaction score
1
I've come across some decent SQL injection preventions by implementing parameterized queries or using an ORM that takes care of this for you. Oracle's "PL/SQL" can also help prevent SQL injections to some extent. Has anyone had any hands-on experience with the OWASP SQLi validation library?
 

Герберт

New member
Joined
Dec 13, 2008
Messages
4
Reaction score
0
"SQLi's a mess, I've seen some sites get totally pwned by it. One thing that's always helped me is whitelisting inputs and limiting db privileges, makes it harder for attackers to wreak havoc. Anyone have some experience with OWASP ZAP for detecting vulnerabilities?"
 
Top