Total Articles 215
2010.10.04 02:56:51
2155
Table of Contents
OVERVIEW 3
WHAT ARE PERSONAS 3
Business Decision Maker 4
Architect 4
Developer 4
Tester/QA 4
UNDERSTANDING SQL INJECTION FOR THE BUSINESS DECISION MAKER 4
Risk 4
Business Impact 5
Fixing the Code 6
Resources and Training for Business Decision Makers 7
UNDERSTANDING SQL INJECTION FOR THE ARCHITECT/PM 7
Identifying the Problem 7
Common SQL Injection Attacks 7
Designing a Fix 7
Tools for Designing Software That Prevents SQL Injection Vulnerabilities 9
Resources and Training for Architects/PMs 9
UNDERSTANDING SQL INJECTION ATTACKS FOR THE DEVELOPER 9
Example of SQL Injection 9
Example of a SQL Injection by Truncation Attack 10
Writing Secure Code 12
Constrain Input 12
Use Parameterized SQL Queries 13
Use Proper Escaping Techniques to Handle Special Input Characters 14
Calculate Buffer Lengths Properly 15
Additional Considerations 16
Use a Least-Privileged Database Account 16
Avoid Disclosing Detailed Error Information 16
Tools and Libraries 17
Resources and Training for Developers 17
UNDERSTANDING SQL INJECTION VULNERABILITIES FOR THE TESTER/QA 17
Map Out the Site and Its Functionality 17
Start Testing and Pay Attention to the Output 18
Techniques for Finding Various Types of SQL Injection Vulnerabilities 18
Code Reviews 18
Building Improvements into Black Box Testing 19
Tools You Can Use 19
Resources and Training for Testers 19
THE MICROSOFT SDL AND PREVENTING SQL INJECTION ATTACKS 20
Long-Term Solutions 20
CONCLUSION 21
ACKNOWLEDGMENTS 21
OVERVIEW 3
WHAT ARE PERSONAS 3
Business Decision Maker 4
Architect 4
Developer 4
Tester/QA 4
UNDERSTANDING SQL INJECTION FOR THE BUSINESS DECISION MAKER 4
Risk 4
Business Impact 5
Fixing the Code 6
Resources and Training for Business Decision Makers 7
UNDERSTANDING SQL INJECTION FOR THE ARCHITECT/PM 7
Identifying the Problem 7
Common SQL Injection Attacks 7
Designing a Fix 7
Tools for Designing Software That Prevents SQL Injection Vulnerabilities 9
Resources and Training for Architects/PMs 9
UNDERSTANDING SQL INJECTION ATTACKS FOR THE DEVELOPER 9
Example of SQL Injection 9
Example of a SQL Injection by Truncation Attack 10
Writing Secure Code 12
Constrain Input 12
Use Parameterized SQL Queries 13
Use Proper Escaping Techniques to Handle Special Input Characters 14
Calculate Buffer Lengths Properly 15
Additional Considerations 16
Use a Least-Privileged Database Account 16
Avoid Disclosing Detailed Error Information 16
Tools and Libraries 17
Resources and Training for Developers 17
UNDERSTANDING SQL INJECTION VULNERABILITIES FOR THE TESTER/QA 17
Map Out the Site and Its Functionality 17
Start Testing and Pay Attention to the Output 18
Techniques for Finding Various Types of SQL Injection Vulnerabilities 18
Code Reviews 18
Building Improvements into Black Box Testing 19
Tools You Can Use 19
Resources and Training for Testers 19
THE MICROSOFT SDL AND PREVENTING SQL INJECTION ATTACKS 20
Long-Term Solutions 20
CONCLUSION 21
ACKNOWLEDGMENTS 21

 
 




steviiy
vikasrao

Thank you for your file.