OWASP - User contributions [en]

Threat Modeling Cheat Sheet

2017-08-22T00:43:42Z

AnnGrove: /* Why do we need to perform threat modeling */ Minor grammar edits. Clarifications.

__NOTOC__
<div style="width:100%;height:160px;border:0,margin:0;overflow: hidden;">[[File:Cheatsheets-header.jpg|link=]]</div>

{| style="padding: 0;margin:0;margin-top:10px;text-align:left;" |-
| valign="top" style="border-right: 1px dotted gray;padding-right:25px;" |
Last revision (mm/dd/yy): '''{{REVISIONMONTH}}/{{REVISIONDAY}}/{{REVISIONYEAR}}'''
<br />
__TOC__{{TOC hidden}}
= DRAFT CHEAT SHEET - WORK IN PROGRESS =
= Introduction =

The objective of this cheat sheet is to provide guidance to developers, reviewers, designers and architects on conducting successful threat modeling. The main goal of threat modeling is to understand the controls needed for a software system. This is a complex endeavor that will involve investigations into:
# The trust boundaries to and within the solution that we build
# The actors that interact within and outside of the trust boundaries
# Information flows within and to and from the trust boundaries
# Information persistence within and out of trust boundaries
# Vulnerabilities at trust boundaries
# Threat agents that can exploit the vulnerabilities
# Impact of exploitation of vulnerability by a threat agents
# Controls and process needed to treat specific risks

=Why do we need to perform threat modeling=

1. Performing threat model at the architecture level, helps in:
a. confirming suitability of the identified security features to be implemented
b. identification of any gaps in the security features to be implemented
c. identification of any further security features
d. identification of policy and process requirements
e. identification of requirements to be fed into security operations
f. identification of logging and monitoring requirements
g. arriving at abuse cases when used in agile methodology
h. understanding business continuity requirements
i. understanding capacity and availability requirements

2. Performing threat model at the design level, helps in:
a. identification of vulnerabilities that need to be closed at the design level and input this into the build phase
b. identification of information assets that need security controls
c. mapping of identified security controls into technical / administrative / physical controls as the case may be (this activity can be done at the architecture level as well, but doing it at the design level helps in being granular)
d. identification of security test cases / security test scenarios to test the security requirements

=Starting the threat modeling exercise=
It is important for an organization to have or create a risk assessment policy that gives practitioner guidance on when to do a threat model, provides management guidance on assigning owners to risks, etc.

An organization should also complete the following before beginning the threat modeling exercise:

1. Make a list of all the stakeholders who need to participate in threat modeling. For example, stakeholders may include application architects, infrastructure architects, solution architects, business owners, etc.

2. Get management buy-in for the exercise to ensure that there is management support for involvement of all necessary stakeholders.

3. Confirm that the threat modeling exercise is led by the security team of the organisation and the risk log is maintained by the security team.

Capturing the following information is part of the exercise:

1. The trust boundaries to and within the solution that we build

2. The actors that interact within and outside of the trust boundaries

3. Information flows within and to and from the trust boundaries

4. Information persistence within and out of trust boundaries

5. Threats to transgression of trust boundaries by actors and for information flow and persistence

6. Vulnerabilities at trust boundaries as accessed by actors and for information flow and persistence

7. Threat agents that can exploit the vulnerabilities

8. Impact of exploitation of vulnerability by a threat agent

9. Decision tree to treat the risk

=Decompose and Model the system=

To perform a threat model, it is important to understand how the system works and interacts with its ecosystem.
To start with, create a high level information flow diagram, something like this:

<<Picture to be embedded>>

1. Identify the trusted boundaries of your system / application / module / ecosystem that you may want to start off with.

2. Add actors – internal and external

3. Define internal trusted boundaries. These can be the different security zones that have been designed

4. Relook at the actors you have identified in #2 for consistency

5. Add information flows
a. Information in transit
b. Information at rest
c. Information processing
d. In the above diagram, following are the information flows:
i. Login Information
ii. Transmit login information
iii. Data process
iv. Data store

6. Identify the information elements and their classification as per your information classification policy

7. Where possible add assets to the identified information flows

8. Identify threat agents for each of the information flows

9. Draw attack vectors and attack trees in an iteratively to make sure that no major attack vector is missed.

10. For each of the information flows perform threat assessment using any of the methodologies that meets the organisation’s requirements:

11. Add a probability value to the materialisation of each threat

12. Add a value for the impact of each threat materialisation

13. Identify the acceptable level of risk for the organisation or the identified scope

14. Identify the risks for mitigation that are above the acceptable level of risk

15. Mitigate the risks by doing one or more of the following:
a. Accept
b. Transfer
c. Avoid
d. Reduce

=How to work on getting the mitigations in place, track them to closure and keep monitoring risks=
1. Upon completion of the initial threat modelling exercise, assign identified risks to the relevant business / risk owners of threats for example
a. If there is an identified risk with the way the database is implemented, assign the risk responsibility to the owner of the database team.
b. If there is an identified risk with the application design, assign the risk responsibility to the owner of the application team
c. Although the risks are assigned to the database and application teams, the accountability of ensuring the risks are addressed lies with the business owner for the business the application is being developed for. At the end of the day, the business owner needs to understand the risk appetite of his/her business unit and whether the risk is above or below the acceptable level.

2. Maintain a Threat Traceability Matrix which at the minimum lists the following:
a. Information flow (along with the list of assets)
b. Threats for the information flows
c. Probability of occurrence of the risk
d. Impact of materialisation of the risk
e. Risk owner – responsibility wise
f. Risk owner – accountability wise
g. Mitigation
h. Last review date
i. Next review date
j. Instances of materialisation of the risk

3. Test the risk as a part of security testing to ensure that the mitigation works as expected

Periodically retest the risk in either a vulnerability scan or as part of penetration test or security test to ensure that the mitigation remains in place and works as expected.

=Further Reading=
https://www.owasp.org/index.php/Application_Threat_Modeling

== Authors and Primary Editors ==

TODO

== Other Cheatsheets ==

{{Cheatsheet_Navigation_Body}}
[[Category:Cheatsheets]]
|}

SQL Injection Prevention Cheat Sheet

2017-07-19T16:16:07Z

AnnGrove: /* Defense Option 4: Escaping All User-Supplied Input */

__NOTOC__
<div style="width:100%;height:160px;border:0,margin:0;overflow: hidden;">[[File:Cheatsheets-header.jpg|link=]]</div>

Last revision (mm/dd/yy): '''{{REVISIONMONTH}}/{{REVISIONDAY}}/{{REVISIONYEAR}}'''
= Introduction =
__TOC__{{TOC hidden}}

This article is focused on providing clear, simple, actionable guidance for preventing SQL Injection flaws in your applications. [[SQL Injection]] attacks are unfortunately very common, and this is due to two factors:

# the significant prevalence of SQL Injection vulnerabilities, and
# the attractiveness of the target (i.e., the database typically contains all the interesting/critical data for your application).

It’s somewhat shameful that there are so many successful SQL Injection attacks occurring, because it is EXTREMELY simple to avoid SQL Injection vulnerabilities in your code.

SQL Injection flaws are introduced when software developers create dynamic database queries that include user supplied input. To avoid SQL injection flaws is simple. Developers need to either:
a) stop writing dynamic queries; and/or
b) prevent user supplied input which contains malicious SQL from affecting the logic of the executed query.

This article provides a set of simple techniques for preventing SQL Injection vulnerabilities by avoiding these two problems. These techniques can be used with practically any kind of programming language with any type of database. There are other types of databases, like XML databases, which can have similar problems (e.g., XPath and XQuery injection) and these techniques can be used to protect them as well.

Primary Defenses:
* '''Option 1: Use of Prepared Statements (with Parameterized Queries)'''
* '''Option 2: Use of Stored Procedures'''
* '''Option 3: White List Input Validation'''
* '''Option 4: Escaping All User Supplied Input'''

Additional Defenses:
* '''Also: Enforcing Least Privilege'''
* '''Also: Performing White List Input Validation as a Secondary Defense'''
<br>
;Unsafe Example

SQL injection flaws typically look like this:

The following (Java) example is UNSAFE, and would allow an attacker to inject code into the query that would be executed by the database. The unvalidated “customerName” parameter that is simply appended to the query allows an attacker to inject any SQL code they want. Unfortunately, this method for accessing databases is all too common.

String query = "SELECT account_balance FROM user_data WHERE user_name = "
+ request.getParameter("customerName");

try {
Statement statement = connection.createStatement( … );
ResultSet results = statement.executeQuery( query );
}

=Primary Defenses=

==Defense Option 1: Prepared Statements (with Parameterized Queries)==

The use of prepared statements with variable binding (aka parameterized queries) is how all developers should first be taught how to write database queries. They are simple to write, and easier to understand than dynamic queries. Parameterized queries force the developer to first define all the SQL code, and then pass in each parameter to the query later. This coding style allows the database to distinguish between code and data, regardless of what user input is supplied.

Prepared statements ensure that an attacker is not able to change the intent of a query, even if SQL commands are inserted by an attacker. In the safe example below, if an attacker were to enter the userID of tom' or '1'='1, the parameterized query would not be vulnerable and would instead look for a username which literally matched the entire string tom' or '1'='1.

Language specific recommendations:
* Java EE – use PreparedStatement() with bind variables
* .NET – use parameterized queries like SqlCommand() or OleDbCommand() with bind variables
* PHP – use PDO with strongly typed parameterized queries (using bindParam())
* Hibernate - use createQuery() with bind variables (called named parameters in Hibernate)
* SQLite - use sqlite3_prepare() to create a [http://www.sqlite.org/c3ref/stmt.html statement object]

In rare circumstances, prepared statements can harm performance. When confronted with this situation, it is best to either a) strongly validate all data or b) escape all user supplied input using an escaping routine specific to your database vendor as described below, rather than using a prepared statement.

;Safe Java Prepared Statement Example

The following code example uses a PreparedStatement, Java's implementation of a parameterized query, to execute the same database query.

String custname = request.getParameter("customerName"); // This should REALLY be validated too
// perform input validation to detect attacks
String query = "SELECT account_balance FROM user_data WHERE user_name = ? ";

'''PreparedStatement pstmt = connection.prepareStatement( query );'''
'''pstmt.setString( 1, custname); '''
ResultSet results = pstmt.executeQuery( );

;Safe C# .NET Prepared Statement Example

With .NET, it's even more straightforward. The creation and execution of the query doesn't change. All you have to do is simply pass the parameters to the query using the Parameters.Add() call as shown here.

String query =
"SELECT account_balance FROM user_data WHERE user_name = ?";
try {
OleDbCommand command = new OleDbCommand(query, connection);
'''command.Parameters.Add(new OleDbParameter("customerName", CustomerName Name.Text));'''
OleDbDataReader reader = command.ExecuteReader();
// …
} catch (OleDbException se) {
// error handling
}

We have shown examples in Java and .NET but practically all other languages, including Cold Fusion, and Classic ASP, support parameterized query interfaces. Even SQL abstraction layers, like the [http://www.hibernate.org/ Hibernate Query Language] (HQL) have the same type of injection problems (which we call [http://cwe.mitre.org/data/definitions/564.html HQL Injection]). HQL supports parameterized queries as well, so we can avoid this problem:

;Hibernate Query Language (HQL) Prepared Statement (Named Parameters) Examples

First is an unsafe HQL Statement

Query unsafeHQLQuery = session.createQuery("from Inventory where productID='"+userSuppliedParameter+"'");

Here is a safe version of the same query using named parameters

Query safeHQLQuery = session.createQuery("from Inventory where productID=:productid");
safeHQLQuery.setParameter("productid", userSuppliedParameter);

For examples of parameterized queries in other languages, including Ruby, PHP, Cold Fusion, and Perl, see the [[Query Parameterization Cheat Sheet]] or http://bobby-tables.com/.

Developers tend to like the Prepared Statement approach because all the SQL code stays within the application. This makes your application relatively database independent.

== Defense Option 2: Stored Procedures ==

Stored procedures are not always safe from SQL injection. However, certain standard stored procedure programming constructs have the same effect as the use of parameterized queries when implemented safely* which is the norm for most stored procedure languages. They require the developer to just build SQL statements with parameters which are automatically parameterized unless the developer does something largely out of the norm. The difference between prepared statements and stored procedures is that the SQL code for a stored procedure is defined and stored in the database itself, and then called from the application. Both of these techniques have the same effectiveness in preventing SQL injection so your organization should choose which approach makes the most sense for you.

*Note: 'Implemented safely' means the stored procedure does not include any unsafe dynamic SQL generation. Developers do not usually generate dynamic SQL inside stored procedures. However, it can be done, but should be avoided. If it can't be avoided, the stored procedure must use input validation or proper escaping as described in this article to make sure that all user supplied input to the stored procedure can't be used to inject SQL code into the dynamically generated query. Auditors should always look for uses of sp_execute, execute or exec within SQL Server stored procedures. Similar audit guidelines are necessary for similar functions for other vendors.

There are also several cases where stored procedures can increase risk. For example, on MS SQL server, you have 3 main default roles: db_datareader, db_datawriter and db_owner. Before stored procedures came into use, DBA's would give db_datareader or db_datawriter rights to the webservice's user, depending on the requirements. However, stored procedures require execute rights, a role that is not available by default. Some setups where the user management has been centralized, but is limited to those 3 roles, cause all web apps to run under db_owner rights so stored procedures can work. Naturally, that means that if a server is breached the attacker has full rights to the database, where previously they might only have had read-access. More on this topic here. http://www.sqldbatips.com/showarticle.asp?ID=8

;Safe Java Stored Procedure Example

The following code example uses a CallableStatement, Java's implementation of the stored procedure interface, to execute the same database query. The "sp_getAccountBalance" stored procedure would have to be predefined in the database and implement the same functionality as the query defined above.

String custname = request.getParameter("customerName"); // This should REALLY be validated
try {
'''CallableStatement cs = connection.prepareCall("{call sp_getAccountBalance(?)}");'''
'''cs.setString(1, custname);'''
ResultSet results = cs.executeQuery();
// … result set handling
} catch (SQLException se) {
// … logging and error handling
}

;Safe VB .NET Stored Procedure Example

The following code example uses a SqlCommand, .NET’s implementation of the stored procedure interface, to execute the same database query. The "sp_getAccountBalance" stored procedure would have to be predefined in the database and implement the same functionality as the query defined above.

Try
Dim command As SqlCommand = new SqlCommand("sp_getAccountBalance", connection)
'''command.CommandType = CommandType.StoredProcedure'''
'''command.Parameters.Add(new SqlParameter("@CustomerName", CustomerName.Text))'''
Dim reader As SqlDataReader = command.ExecuteReader()
‘ …
Catch se As SqlException
‘ error handling
End Try

== Defense Option 3: White List Input Validation ==

Various parts of SQL queries aren't legal locations for the use of bind variables, such as the names of tables or columns, and the sort order indicator (ASC or DESC). In such situations, input validation or query redesign is the most appropriate defense. For the names of tables or columns, ideally those values come from the code, and not from user parameters. But if user parameter values are used to make different for table names and column names, then the parameter values should be mapped to the legal/expected table or column names to make sure unvalidated user input doesn't end up in the query. Please note, this is a symptom of poor design and a full re-write should be considered if time allows. Here is an example of table name validation.

String tableName;
switch(PARAM):
case "Value1": tableName = "fooTable";
break;
case "Value2": tableName = "barTable";
break;
...
default : throw new InputValidationException("unexpected value provided for table name");

The tableName can then be directly appended to the SQL query since it is now known to be one of the legal and expected values for a table name in this query. Keep in mind that generic table validation functions can lead to data loss as table names are used in queries where they are not expected.

For something simple like a sort order, it would be best if the user supplied input is converted to a boolean, and then that boolean is used to select the safe value to append to the query. This is a very standard need in dynamic query creation. For example:

public String someMethod(boolean sortOrder) {

String SQLquery = "some SQL ... order by Salary " + (sortOrder ? "ASC" : "DESC");
...

Any time user input can be converted to a non-String, like a date, numeric, boolean, enumerated type, etc. before it is appended to a query, or used to select a value to append to the query, this ensures it is safe to do so.

Input validation is also recommended as a secondary defense in ALL cases, even when using bind variables as is discussed later in this article. More techniques on how to implement strong white list input validation is described in the [[Input Validation Cheat Sheet]].

==Defense Option 4: Escaping All User-Supplied Input==

This technique should only be used as a last resort, when none of the above are feasible. Input validation is probably a better choice as this methodology is frail compared to other defenses and we cannot guarantee it will prevent all SQL Injection in all situations.

This technique is to escape user input before putting it in a query. It is very database specific in its implementation. It's usually only recommended to retrofit legacy code when implementing input validation isn't cost effective. Applications built from scratch, or applications requiring low risk tolerance should be built or re-written using parameterized queries, stored procedures, or some kind of Object Relational Mapper (ORM) that builds your queries for you.

This technique works like this. Each DBMS supports one or more character escaping schemes specific to certain kinds of queries. If you then escape all user supplied input using the proper escaping scheme for the database you are using, the DBMS will not confuse that input with SQL code written by the developer, thus avoiding any possible SQL injection vulnerabilities.

The OWASP Enterprise Security API (ESAPI) is a free, open source, web application security control library that makes it easier for programmers to write lower-risk applications. The ESAPI libraries are designed to make it easier for programmers to retrofit security into existing applications. The ESAPI libraries also serve as a solid foundation for new development.

* Full details on [https://www.owasp.org/index.php/Category:OWASP_Enterprise_Security_API ESAPI are available here on OWASP].
* The javadoc for [http://www.javadoc.io/doc/org.owasp.esapi/esapi/2.1.0 ESAPI 2.x (Legacy) is available]. This code was migrated to GitHub in November 2014.
* Directly [http://code.google.com/p/owasp-esapi-java/source/browse/#svn/trunk/src/main/java/org/owasp/esapi browse the source for ESAPI for Java 2.x (Legacy) at GitHub], which is frequently helpful if the javadoc isn't perfectly clear.
* Directly [[Https://github.com/ESAPI/esapi-java|browse browse the source for ESAPI for Java 3.x (Active) at GitHub]].

To find the javadoc specifically for the database encoders, click on the ‘Codec’ class on the left hand side. There are lots of Codecs implemented. The two Database specific codecs are OracleCodec, and MySQLCodec.

Just click on their names in the ‘All Known Implementing Classes:’ at the top of the Interface Codec page.

At this time, ESAPI currently has database encoders for:
* Oracle
* MySQL (Both ANSI and native modes are supported)

Database encoders are forthcoming for:
* SQL Server
* PostgreSQL

If your database encoder is missing, please let us know.

===Database Specific Escaping Details===

If you want to build your own escaping routines, here are the escaping details for each of the databases that we have developed ESAPI Encoders for:
* Oracle
* SQL Server
* DB2

====Oracle Escaping====

This information is based on the Oracle Escape character information found here: http://www.orafaq.com/wiki/SQL_FAQ#How_does_one_escape_special_characters_when_writing_SQL_queries.3F

=====Escaping Dynamic Queries=====

To use an ESAPI database codec is pretty simple. An Oracle example looks something like:
ESAPI.encoder().encodeForSQL( new OracleCodec(), queryparam );

So, if you had an existing Dynamic query being generated in your code that was going to Oracle that looked like this:

String query = "SELECT user_id FROM user_data WHERE user_name = '" + req.getParameter("userID")
+ "' and user_password = '" + req.getParameter("pwd") +"'";
try {
Statement statement = connection.createStatement( … );
ResultSet results = statement.executeQuery( query );
}

You would rewrite the first line to look like this:

'''Codec ORACLE_CODEC = new OracleCodec();'''
String query = "SELECT user_id FROM user_data WHERE user_name = '" +
'''ESAPI.encoder().encodeForSQL( ORACLE_CODEC, req.getParameter("userID"))''' + "' and user_password = '"
+ '''ESAPI.encoder().encodeForSQL( ORACLE_CODEC, req.getParameter("pwd"))''' +"'";

And it would now be safe from SQL injection, regardless of the input supplied.

For maximum code readability, you could also construct your own OracleEncoder.

Encoder oe = new OracleEncoder();
String query = "SELECT user_id FROM user_data WHERE user_name = '"
+ '''oe.encode( req.getParameter("userID"))''' + "' and user_password = '"
+ '''oe.encode( req.getParameter("pwd"))''' +"'";

With this type of solution, you would need only to wrap each user-supplied parameter being passed into an '''ESAPI.encoder().encodeForOracle( )''' call or whatever you named the call and you would be done.

=====Turn off character replacement=====

Use SET DEFINE OFF or SET SCAN OFF to ensure that automatic character replacement is turned off. If this character replacement is turned on, the & character will be treated like a SQLPlus variable prefix that could allow an attacker to retrieve private data.

See http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12040.htm#i2698854 and http://stackoverflow.com/questions/152837/how-to-insert-a-string-which-contains-an for more information

=====Escaping Wildcard characters in Like Clauses=====

The LIKE keyword allows for text scanning searches. In Oracle, the underscore '_' character matches only one character, while the ampersand '%' is used to match zero or more occurrences of any characters. These characters must be escaped in LIKE clause criteria. For example:

SELECT name FROM emp
WHERE id LIKE '%/_%' ESCAPE '/';

SELECT name FROM emp
WHERE id LIKE '%\%%' ESCAPE '\';

=====Oracle 10g escaping=====

<nowiki>An alternative for Oracle 10g and later is to place { and } around the string to escape the entire string. However, you have to be careful that there isn't a } character already in the string. You must search for these and if there is one, then you must replace it with }}. Otherwise that character will end the escaping early, and may introduce a vulnerability.</nowiki>

====MySQL Escaping====

MySQL supports two escaping modes:

# ANSI_QUOTES SQL mode, and a mode with this off, which we call
# MySQL mode.

ANSI SQL mode: Simply encode all ' (single tick) characters with '' (two single ticks)

MySQL mode, do the following:

NUL (0x00) --> \0 [This is a zero, not the letter O]
BS (0x08) --> \b
TAB (0x09) --> \t
LF (0x0a) --> \n
CR (0x0d) --> \r
SUB (0x1a) --> \Z
" (0x22) --> \"
% (0x25) --> \%
' (0x27) --> \'
\ (0x5c) --> \\
_ (0x5f) --> \_
all other non-alphanumeric characters with ASCII values less than 256 --> \c
where 'c' is the original non-alphanumeric character.

This information is based on the MySQL Escape character information found here: http://mirror.yandex.ru/mirrors/ftp.mysql.com/doc/refman/5.0/en/string-syntax.html

====SQL Server Escaping====

We have not implemented the SQL Server escaping routine yet, but the following has good pointers and links to articles describing how to prevent SQL injection attacks on SQL server
* http://blogs.msdn.com/raulga/archive/2007/01/04/dynamic-sql-sql-injection.aspx

====DB2 Escaping====
This information is based on DB2 WebQuery special characters found here: https://www-304.ibm.com/support/docview.wss?uid=nas14488c61e3223e8a78625744f00782983
as well as some information from Oracle's JDBC DB2 driver found here:
http://docs.oracle.com/cd/E12840_01/wls/docs103/jdbc_drivers/sqlescape.html

Information in regards to differences between several DB2 Universal drivers can be found here: http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/rjvjcsqc.htm

===Hex-encoding all input===

A somewhat special case of escaping is the process of hex-encode the entire string received from the user (this can be seen as escaping every character). The web application should hex-encode the user input before including it in the SQL statement. The SQL statement should take into account this fact, and accordingly compare the data. For example, if we have to look up a record matching a sessionID, and the user transmitted the string abc123 as the session ID, the select statement would be:

SELECT ... FROM session
WHERE hex_encode (sessionID) = '616263313233'

(hex_encode should be replaced by the particular facility for the database being used.) The string 606162313233 is the hex encoded version of the string received from the user (it is the sequence of hex values of the ASCII/UTF-8 codes of the user data).

If an attacker were to transmit a string containing a single-quote character followed by their attempt to inject SQL code, the constructed SQL statement will only look like:

WHERE hex_encode ( ... ) = '2720 ... '

27 being the ASCII code (in hex) of the single-quote, which is simply hex-encoded like any other character in the string. The resulting SQL can only contain numeric digits and letters a to f, and never any special character that could enable an SQL injection.

===Escaping SQLi in PHP===

Use prepared statements and parameterized queries. These are SQL statements that are sent to and parsed by the database server separately from any parameters. This way it is impossible for an attacker to inject malicious SQL.

<br>You basically have two options to achieve this:<br>

1. Using [http://php.net/manual/en/book.pdo.php PDO] (for any supported database driver):
<pre>
$stmt = $pdo->prepare('SELECT * FROM employees WHERE name = :name');

$stmt->execute(array('name' => $name));

foreach ($stmt as $row) {
// do something with $row
}
</pre>
2. Using [http://php.net/manual/en/book.mysqli.php MySQLi] (for MySQL):
<pre>
$stmt = $dbConnection->prepare('SELECT * FROM employees WHERE name = ?');
$stmt->bind_param('s', $name);

$stmt->execute();

$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
// do something with $row
}
</pre>
PDO is the universal option. If you're connecting to a database other than MySQL, you can refer to a driver-specific second option (e.g. pg_prepare() and pg_execute() for PostgreSQL).

= Additional Defenses =

Beyond adopting one of the four primary defenses, we also recommend adopting all of these additional defenses in order to provide defense in depth. These additional defenses are:

* '''Least Privilege'''
* '''White List Input Validation'''

== Least Privilege ==

To minimize the potential damage of a successful SQL injection attack, you should minimize the privileges assigned to every database account in your environment. Do not assign DBA or admin type access rights to your application accounts. We understand that this is easy, and everything just ‘works’ when you do it this way, but it is very dangerous. Start from the ground up to determine what access rights your application accounts require, rather than trying to figure out what access rights you need to take away. Make sure that accounts that only need read access are only granted read access to the tables they need access to. If an account only needs access to portions of a table, consider creating a view that limits access to that portion of the data and assigning the account access to the view instead, rather than the underlying table. Rarely, if ever, grant create or delete access to database accounts.

If you adopt a policy where you use stored procedures everywhere, and don’t allow application accounts to directly execute their own queries, then restrict those accounts to only be able to execute the stored procedures they need. Don’t grant them any rights directly to the tables in the database.

SQL injection is not the only threat to your database data. Attackers can simply change the parameter values from one of the legal values they are presented with, to a value that is unauthorized for them, but the application itself might be authorized to access. As such, minimizing the privileges granted to your application will reduce the likelihood of such unauthorized access attempts, even when an attacker is not trying to use SQL injection as part of their exploit.

While you are at it, you should minimize the privileges of the operating system account that the DBMS runs under. Don't run your DBMS as root or system! Most DBMSs run out of the box with a very powerful system account. For example, MySQL runs as system on Windows by default! Change the DBMS's OS account to something more appropriate, with restricted privileges.

=== Multiple DB Users ===

The designer of web applications should not only avoid using the same owner/admin account in the web applications to connect to the database. Different DB users could be used for different web applications. In general, each separate web application that requires access to the database could have a designated database user account that the web-app will use to connect to the DB. That way, the designer of the application can have good granularity in the access control, thus reducing the privileges as much as possible. Each DB user will then have select access to what it needs only, and write-access as needed.

As an example, a login page requires read access to the username and password fields of a table, but no write access of any form (no insert, update, or delete). However, the sign-up page certainly requires insert privilege to that table; this restriction can only be enforced if these web apps use different DB users to connect to the database.

=== Views ===

You can use SQL views to further increase the granularity of access by limiting the read access to specific fields of a table or joins of tables. It could potentially have additional benefits: for example, suppose that the system is required (perhaps due to some specific legal requirements) to store the passwords of the users, instead of salted-hashed passwords. The designer could use views to compensate for this limitation; revoke all access to the table (from all DB users except the owner/admin) and create a view that outputs the hash of the password field and not the field itself. Any SQL injection attack that succeeds in stealing DB information will be restricted to stealing the hash of the passwords (could even be a keyed hash), since no DB user for any of the web applications has access to the table itself.

== White List Input Validation ==

In addition to being a primary defense when nothing else is possible (e.g., when a bind variable isn't legal), input validation can also be a secondary defense used to detect unauthorized input before it is passed to the SQL query. For more information please see the [[Input Validation Cheat Sheet]]. Proceed with caution here. Validated data is not necessarily safe to insert into SQL queries via string building.
<br /><br />

=Related Articles=

'''SQL Injection Attack Cheat Sheets'''

The following articles describe how to exploit different kinds of SQL Injection Vulnerabilities on various platforms that this article was created to help you avoid:

* "SQL Injection Cheat Sheet" - http://ferruh.mavituna.com/sql-injection-cheatsheet-oku/
* "Bypassing WAF's with SQLi" - [[SQL Injection Bypassing WAF]]

'''Description of SQL Injection Vulnerabilities'''

* OWASP article on [[SQL Injection]] Vulnerabilities
* OWASP article on [[Blind_SQL_Injection]] Vulnerabilities

'''How to Avoid SQL Injection Vulnerabilities'''

* [[:Category:OWASP Guide Project|OWASP Developers Guide]] article on how to [[Guide to SQL Injection | Avoid SQL Injection]] Vulnerabilities
* OWASP Cheat Sheet that provides [[Query_Parameterization_Cheat_Sheet|numerous language specific examples of parameterized queries using both Prepared Statements and Stored Procedures]]
* [http://bobby-tables.com/ The Bobby Tables site (inspired by the XKCD webcomic) has numerous examples in different languages of parameterized Prepared Statements and Stored Procedures]

'''How to Review Code for SQL Injection Vulnerabilities'''

* [[:Category:OWASP Code Review Project|OWASP Code Review Guide]] article on how to [[Reviewing Code for SQL Injection|Review Code for SQL Injection]] Vulnerabilities

'''How to Test for SQL Injection Vulnerabilities'''

* [[:Category:OWASP Testing Project|OWASP Testing Guide]] article on how to [[Testing for SQL Injection (OWASP-DV-005)|Test for SQL Injection]] Vulnerabilities

<br /><br />

= Authors and Primary Editors =

[[User:wichers|Dave Wichers]] - dave.wichers[at]owasp.org<br />
[[User:jmanico|Jim Manico]] - jim[at]owasp.org<br />
Matt Seil - mseil[at]acm.org<br>
[https://owasp.org/index.php/Dhiraj_Mishra Dhiraj Mishra] - mishra.dhiraj[at]owasp.org

<br />
== Other Cheatsheets ==

{{Cheatsheet_Navigation_Body}}

[[Category:Cheatsheets]]
[[Category:Popular]]

SQL Injection Prevention Cheat Sheet

2017-07-19T15:40:22Z

AnnGrove: /* Database Specific Escaping Details */ i added one too many bullets, so ... removed a bullet

__NOTOC__
<div style="width:100%;height:160px;border:0,margin:0;overflow: hidden;">[[File:Cheatsheets-header.jpg|link=]]</div>

Last revision (mm/dd/yy): '''{{REVISIONMONTH}}/{{REVISIONDAY}}/{{REVISIONYEAR}}'''
= Introduction =
__TOC__{{TOC hidden}}

This article is focused on providing clear, simple, actionable guidance for preventing SQL Injection flaws in your applications. [[SQL Injection]] attacks are unfortunately very common, and this is due to two factors:

# the significant prevalence of SQL Injection vulnerabilities, and
# the attractiveness of the target (i.e., the database typically contains all the interesting/critical data for your application).

It’s somewhat shameful that there are so many successful SQL Injection attacks occurring, because it is EXTREMELY simple to avoid SQL Injection vulnerabilities in your code.

SQL Injection flaws are introduced when software developers create dynamic database queries that include user supplied input. To avoid SQL injection flaws is simple. Developers need to either:
a) stop writing dynamic queries; and/or
b) prevent user supplied input which contains malicious SQL from affecting the logic of the executed query.

This article provides a set of simple techniques for preventing SQL Injection vulnerabilities by avoiding these two problems. These techniques can be used with practically any kind of programming language with any type of database. There are other types of databases, like XML databases, which can have similar problems (e.g., XPath and XQuery injection) and these techniques can be used to protect them as well.

Primary Defenses:
* '''Option 1: Use of Prepared Statements (with Parameterized Queries)'''
* '''Option 2: Use of Stored Procedures'''
* '''Option 3: White List Input Validation'''
* '''Option 4: Escaping All User Supplied Input'''

Additional Defenses:
* '''Also: Enforcing Least Privilege'''
* '''Also: Performing White List Input Validation as a Secondary Defense'''
<br>
;Unsafe Example

SQL injection flaws typically look like this:

The following (Java) example is UNSAFE, and would allow an attacker to inject code into the query that would be executed by the database. The unvalidated “customerName” parameter that is simply appended to the query allows an attacker to inject any SQL code they want. Unfortunately, this method for accessing databases is all too common.

String query = "SELECT account_balance FROM user_data WHERE user_name = "
+ request.getParameter("customerName");

try {
Statement statement = connection.createStatement( … );
ResultSet results = statement.executeQuery( query );
}

=Primary Defenses=

==Defense Option 1: Prepared Statements (with Parameterized Queries)==

The use of prepared statements with variable binding (aka parameterized queries) is how all developers should first be taught how to write database queries. They are simple to write, and easier to understand than dynamic queries. Parameterized queries force the developer to first define all the SQL code, and then pass in each parameter to the query later. This coding style allows the database to distinguish between code and data, regardless of what user input is supplied.

Prepared statements ensure that an attacker is not able to change the intent of a query, even if SQL commands are inserted by an attacker. In the safe example below, if an attacker were to enter the userID of tom' or '1'='1, the parameterized query would not be vulnerable and would instead look for a username which literally matched the entire string tom' or '1'='1.

Language specific recommendations:
* Java EE – use PreparedStatement() with bind variables
* .NET – use parameterized queries like SqlCommand() or OleDbCommand() with bind variables
* PHP – use PDO with strongly typed parameterized queries (using bindParam())
* Hibernate - use createQuery() with bind variables (called named parameters in Hibernate)
* SQLite - use sqlite3_prepare() to create a [http://www.sqlite.org/c3ref/stmt.html statement object]

In rare circumstances, prepared statements can harm performance. When confronted with this situation, it is best to either a) strongly validate all data or b) escape all user supplied input using an escaping routine specific to your database vendor as described below, rather than using a prepared statement.

;Safe Java Prepared Statement Example

The following code example uses a PreparedStatement, Java's implementation of a parameterized query, to execute the same database query.

String custname = request.getParameter("customerName"); // This should REALLY be validated too
// perform input validation to detect attacks
String query = "SELECT account_balance FROM user_data WHERE user_name = ? ";

'''PreparedStatement pstmt = connection.prepareStatement( query );'''
'''pstmt.setString( 1, custname); '''
ResultSet results = pstmt.executeQuery( );

;Safe C# .NET Prepared Statement Example

With .NET, it's even more straightforward. The creation and execution of the query doesn't change. All you have to do is simply pass the parameters to the query using the Parameters.Add() call as shown here.

String query =
"SELECT account_balance FROM user_data WHERE user_name = ?";
try {
OleDbCommand command = new OleDbCommand(query, connection);
'''command.Parameters.Add(new OleDbParameter("customerName", CustomerName Name.Text));'''
OleDbDataReader reader = command.ExecuteReader();
// …
} catch (OleDbException se) {
// error handling
}

We have shown examples in Java and .NET but practically all other languages, including Cold Fusion, and Classic ASP, support parameterized query interfaces. Even SQL abstraction layers, like the [http://www.hibernate.org/ Hibernate Query Language] (HQL) have the same type of injection problems (which we call [http://cwe.mitre.org/data/definitions/564.html HQL Injection]). HQL supports parameterized queries as well, so we can avoid this problem:

;Hibernate Query Language (HQL) Prepared Statement (Named Parameters) Examples

First is an unsafe HQL Statement

Query unsafeHQLQuery = session.createQuery("from Inventory where productID='"+userSuppliedParameter+"'");

Here is a safe version of the same query using named parameters

Query safeHQLQuery = session.createQuery("from Inventory where productID=:productid");
safeHQLQuery.setParameter("productid", userSuppliedParameter);

For examples of parameterized queries in other languages, including Ruby, PHP, Cold Fusion, and Perl, see the [[Query Parameterization Cheat Sheet]] or http://bobby-tables.com/.

Developers tend to like the Prepared Statement approach because all the SQL code stays within the application. This makes your application relatively database independent.

== Defense Option 2: Stored Procedures ==

Stored procedures are not always safe from SQL injection. However, certain standard stored procedure programming constructs have the same effect as the use of parameterized queries when implemented safely* which is the norm for most stored procedure languages. They require the developer to just build SQL statements with parameters which are automatically parameterized unless the developer does something largely out of the norm. The difference between prepared statements and stored procedures is that the SQL code for a stored procedure is defined and stored in the database itself, and then called from the application. Both of these techniques have the same effectiveness in preventing SQL injection so your organization should choose which approach makes the most sense for you.

*Note: 'Implemented safely' means the stored procedure does not include any unsafe dynamic SQL generation. Developers do not usually generate dynamic SQL inside stored procedures. However, it can be done, but should be avoided. If it can't be avoided, the stored procedure must use input validation or proper escaping as described in this article to make sure that all user supplied input to the stored procedure can't be used to inject SQL code into the dynamically generated query. Auditors should always look for uses of sp_execute, execute or exec within SQL Server stored procedures. Similar audit guidelines are necessary for similar functions for other vendors.

There are also several cases where stored procedures can increase risk. For example, on MS SQL server, you have 3 main default roles: db_datareader, db_datawriter and db_owner. Before stored procedures came into use, DBA's would give db_datareader or db_datawriter rights to the webservice's user, depending on the requirements. However, stored procedures require execute rights, a role that is not available by default. Some setups where the user management has been centralized, but is limited to those 3 roles, cause all web apps to run under db_owner rights so stored procedures can work. Naturally, that means that if a server is breached the attacker has full rights to the database, where previously they might only have had read-access. More on this topic here. http://www.sqldbatips.com/showarticle.asp?ID=8

;Safe Java Stored Procedure Example

The following code example uses a CallableStatement, Java's implementation of the stored procedure interface, to execute the same database query. The "sp_getAccountBalance" stored procedure would have to be predefined in the database and implement the same functionality as the query defined above.

String custname = request.getParameter("customerName"); // This should REALLY be validated
try {
'''CallableStatement cs = connection.prepareCall("{call sp_getAccountBalance(?)}");'''
'''cs.setString(1, custname);'''
ResultSet results = cs.executeQuery();
// … result set handling
} catch (SQLException se) {
// … logging and error handling
}

;Safe VB .NET Stored Procedure Example

The following code example uses a SqlCommand, .NET’s implementation of the stored procedure interface, to execute the same database query. The "sp_getAccountBalance" stored procedure would have to be predefined in the database and implement the same functionality as the query defined above.

Try
Dim command As SqlCommand = new SqlCommand("sp_getAccountBalance", connection)
'''command.CommandType = CommandType.StoredProcedure'''
'''command.Parameters.Add(new SqlParameter("@CustomerName", CustomerName.Text))'''
Dim reader As SqlDataReader = command.ExecuteReader()
‘ …
Catch se As SqlException
‘ error handling
End Try

== Defense Option 3: White List Input Validation ==

Various parts of SQL queries aren't legal locations for the use of bind variables, such as the names of tables or columns, and the sort order indicator (ASC or DESC). In such situations, input validation or query redesign is the most appropriate defense. For the names of tables or columns, ideally those values come from the code, and not from user parameters. But if user parameter values are used to make different for table names and column names, then the parameter values should be mapped to the legal/expected table or column names to make sure unvalidated user input doesn't end up in the query. Please note, this is a symptom of poor design and a full re-write should be considered if time allows. Here is an example of table name validation.

String tableName;
switch(PARAM):
case "Value1": tableName = "fooTable";
break;
case "Value2": tableName = "barTable";
break;
...
default : throw new InputValidationException("unexpected value provided for table name");

The tableName can then be directly appended to the SQL query since it is now known to be one of the legal and expected values for a table name in this query. Keep in mind that generic table validation functions can lead to data loss as table names are used in queries where they are not expected.

For something simple like a sort order, it would be best if the user supplied input is converted to a boolean, and then that boolean is used to select the safe value to append to the query. This is a very standard need in dynamic query creation. For example:

public String someMethod(boolean sortOrder) {

String SQLquery = "some SQL ... order by Salary " + (sortOrder ? "ASC" : "DESC");
...

Any time user input can be converted to a non-String, like a date, numeric, boolean, enumerated type, etc. before it is appended to a query, or used to select a value to append to the query, this ensures it is safe to do so.

Input validation is also recommended as a secondary defense in ALL cases, even when using bind variables as is discussed later in this article. More techniques on how to implement strong white list input validation is described in the [[Input Validation Cheat Sheet]].

==Defense Option 4: Escaping All User-Supplied Input==

This technique should only be used as a last resort, when none of the above are feasible. Input validation is probably a better choice as this methodology is frail compared to other defenses and we cannot guarantee it will prevent all SQL Injection in all situations.

This technique is to escape user input before putting it in a query. It is very database specific in its implementation. It's usually only recommended to retrofit legacy code when implementing input validation isn't cost effective. Applications built from scratch, or applications requiring low risk tolerance should be built or re-written using parameterized queries, stored procedures, or some kind of Object Relational Mapper (ORM) that builds your queries for you.

This technique works like this. Each DBMS supports one or more character escaping schemes specific to certain kinds of queries. If you then escape all user supplied input using the proper escaping scheme for the database you are using, the DBMS will not confuse that input with SQL code written by the developer, thus avoiding any possible SQL injection vulnerabilities.

The OWASP Enterprise Security API (ESAPI) is a free, open source, web application security control library that makes it easier for programmers to write lower-risk applications. The ESAPI libraries are designed to make it easier for programmers to retrofit security into existing applications. The ESAPI libraries also serve as a solid foundation for new development.

* Full details on [https://www.owasp.org/index.php/Category:OWASP_Enterprise_Security_API ESAPI are available here on OWASP].
* The javadoc for [http://www.javadoc.io/doc/org.owasp.esapi/esapi/2.1.0 ESAPI 2.x (Legacy) is available]. This code was migrated to GitHub in November 2014.
* Directly [http://code.google.com/p/owasp-esapi-java/source/browse/#svn/trunk/src/main/java/org/owasp/esapi browse the source for ESAPI for Java 2.x (Legacy) at GitHub], which is frequently helpful if the javadoc isn't perfectly clear.
* Directly [[Https://github.com/ESAPI/esapi-java|browse the source for ESAPI for Java 3.x (Active) at GitHub]].

To find the javadoc specifically for the database encoders, click on the ‘Codec’ class on the left hand side. There are lots of Codecs implemented. The two Database specific codecs are OracleCodec, and MySQLCodec.

Just click on their names in the ‘All Known Implementing Classes:’ at the top of the Interface Codec page.

At this time, ESAPI currently has database encoders for:
* Oracle
* MySQL (Both ANSI and native modes are supported)

Database encoders are forthcoming for:
* SQL Server
* PostgreSQL

If your database encoder is missing, please let us know.

===Database Specific Escaping Details===

If you want to build your own escaping routines, here are the escaping details for each of the databases that we have developed ESAPI Encoders for:
* Oracle
* SQL Server
* DB2

====Oracle Escaping====

This information is based on the Oracle Escape character information found here: http://www.orafaq.com/wiki/SQL_FAQ#How_does_one_escape_special_characters_when_writing_SQL_queries.3F

=====Escaping Dynamic Queries=====

To use an ESAPI database codec is pretty simple. An Oracle example looks something like:
ESAPI.encoder().encodeForSQL( new OracleCodec(), queryparam );

So, if you had an existing Dynamic query being generated in your code that was going to Oracle that looked like this:

String query = "SELECT user_id FROM user_data WHERE user_name = '" + req.getParameter("userID")
+ "' and user_password = '" + req.getParameter("pwd") +"'";
try {
Statement statement = connection.createStatement( … );
ResultSet results = statement.executeQuery( query );
}

You would rewrite the first line to look like this:

'''Codec ORACLE_CODEC = new OracleCodec();'''
String query = "SELECT user_id FROM user_data WHERE user_name = '" +
'''ESAPI.encoder().encodeForSQL( ORACLE_CODEC, req.getParameter("userID"))''' + "' and user_password = '"
+ '''ESAPI.encoder().encodeForSQL( ORACLE_CODEC, req.getParameter("pwd"))''' +"'";

And it would now be safe from SQL injection, regardless of the input supplied.

For maximum code readability, you could also construct your own OracleEncoder.

Encoder oe = new OracleEncoder();
String query = "SELECT user_id FROM user_data WHERE user_name = '"
+ '''oe.encode( req.getParameter("userID"))''' + "' and user_password = '"
+ '''oe.encode( req.getParameter("pwd"))''' +"'";

With this type of solution, you would need only to wrap each user-supplied parameter being passed into an '''ESAPI.encoder().encodeForOracle( )''' call or whatever you named the call and you would be done.

=====Turn off character replacement=====

Use SET DEFINE OFF or SET SCAN OFF to ensure that automatic character replacement is turned off. If this character replacement is turned on, the & character will be treated like a SQLPlus variable prefix that could allow an attacker to retrieve private data.

See http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12040.htm#i2698854 and http://stackoverflow.com/questions/152837/how-to-insert-a-string-which-contains-an for more information

=====Escaping Wildcard characters in Like Clauses=====

The LIKE keyword allows for text scanning searches. In Oracle, the underscore '_' character matches only one character, while the ampersand '%' is used to match zero or more occurrences of any characters. These characters must be escaped in LIKE clause criteria. For example:

SELECT name FROM emp
WHERE id LIKE '%/_%' ESCAPE '/';

SELECT name FROM emp
WHERE id LIKE '%\%%' ESCAPE '\';

=====Oracle 10g escaping=====

<nowiki>An alternative for Oracle 10g and later is to place { and } around the string to escape the entire string. However, you have to be careful that there isn't a } character already in the string. You must search for these and if there is one, then you must replace it with }}. Otherwise that character will end the escaping early, and may introduce a vulnerability.</nowiki>

====MySQL Escaping====

MySQL supports two escaping modes:

# ANSI_QUOTES SQL mode, and a mode with this off, which we call
# MySQL mode.

ANSI SQL mode: Simply encode all ' (single tick) characters with '' (two single ticks)

MySQL mode, do the following:

NUL (0x00) --> \0 [This is a zero, not the letter O]
BS (0x08) --> \b
TAB (0x09) --> \t
LF (0x0a) --> \n
CR (0x0d) --> \r
SUB (0x1a) --> \Z
" (0x22) --> \"
% (0x25) --> \%
' (0x27) --> \'
\ (0x5c) --> \\
_ (0x5f) --> \_
all other non-alphanumeric characters with ASCII values less than 256 --> \c
where 'c' is the original non-alphanumeric character.

This information is based on the MySQL Escape character information found here: http://mirror.yandex.ru/mirrors/ftp.mysql.com/doc/refman/5.0/en/string-syntax.html

====SQL Server Escaping====

We have not implemented the SQL Server escaping routine yet, but the following has good pointers and links to articles describing how to prevent SQL injection attacks on SQL server
* http://blogs.msdn.com/raulga/archive/2007/01/04/dynamic-sql-sql-injection.aspx

====DB2 Escaping====
This information is based on DB2 WebQuery special characters found here: https://www-304.ibm.com/support/docview.wss?uid=nas14488c61e3223e8a78625744f00782983
as well as some information from Oracle's JDBC DB2 driver found here:
http://docs.oracle.com/cd/E12840_01/wls/docs103/jdbc_drivers/sqlescape.html

Information in regards to differences between several DB2 Universal drivers can be found here: http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/rjvjcsqc.htm

===Hex-encoding all input===

A somewhat special case of escaping is the process of hex-encode the entire string received from the user (this can be seen as escaping every character). The web application should hex-encode the user input before including it in the SQL statement. The SQL statement should take into account this fact, and accordingly compare the data. For example, if we have to look up a record matching a sessionID, and the user transmitted the string abc123 as the session ID, the select statement would be:

SELECT ... FROM session
WHERE hex_encode (sessionID) = '616263313233'

(hex_encode should be replaced by the particular facility for the database being used.) The string 606162313233 is the hex encoded version of the string received from the user (it is the sequence of hex values of the ASCII/UTF-8 codes of the user data).

If an attacker were to transmit a string containing a single-quote character followed by their attempt to inject SQL code, the constructed SQL statement will only look like:

WHERE hex_encode ( ... ) = '2720 ... '

27 being the ASCII code (in hex) of the single-quote, which is simply hex-encoded like any other character in the string. The resulting SQL can only contain numeric digits and letters a to f, and never any special character that could enable an SQL injection.

===Escaping SQLi in PHP===

Use prepared statements and parameterized queries. These are SQL statements that are sent to and parsed by the database server separately from any parameters. This way it is impossible for an attacker to inject malicious SQL.

<br>You basically have two options to achieve this:<br>

1. Using [http://php.net/manual/en/book.pdo.php PDO] (for any supported database driver):
<pre>
$stmt = $pdo->prepare('SELECT * FROM employees WHERE name = :name');

$stmt->execute(array('name' => $name));

foreach ($stmt as $row) {
// do something with $row
}
</pre>
2. Using [http://php.net/manual/en/book.mysqli.php MySQLi] (for MySQL):
<pre>
$stmt = $dbConnection->prepare('SELECT * FROM employees WHERE name = ?');
$stmt->bind_param('s', $name);

$stmt->execute();

$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
// do something with $row
}
</pre>
PDO is the universal option. If you're connecting to a database other than MySQL, you can refer to a driver-specific second option (e.g. pg_prepare() and pg_execute() for PostgreSQL).

= Additional Defenses =

Beyond adopting one of the four primary defenses, we also recommend adopting all of these additional defenses in order to provide defense in depth. These additional defenses are:

* '''Least Privilege'''
* '''White List Input Validation'''

== Least Privilege ==

To minimize the potential damage of a successful SQL injection attack, you should minimize the privileges assigned to every database account in your environment. Do not assign DBA or admin type access rights to your application accounts. We understand that this is easy, and everything just ‘works’ when you do it this way, but it is very dangerous. Start from the ground up to determine what access rights your application accounts require, rather than trying to figure out what access rights you need to take away. Make sure that accounts that only need read access are only granted read access to the tables they need access to. If an account only needs access to portions of a table, consider creating a view that limits access to that portion of the data and assigning the account access to the view instead, rather than the underlying table. Rarely, if ever, grant create or delete access to database accounts.

If you adopt a policy where you use stored procedures everywhere, and don’t allow application accounts to directly execute their own queries, then restrict those accounts to only be able to execute the stored procedures they need. Don’t grant them any rights directly to the tables in the database.

SQL injection is not the only threat to your database data. Attackers can simply change the parameter values from one of the legal values they are presented with, to a value that is unauthorized for them, but the application itself might be authorized to access. As such, minimizing the privileges granted to your application will reduce the likelihood of such unauthorized access attempts, even when an attacker is not trying to use SQL injection as part of their exploit.

While you are at it, you should minimize the privileges of the operating system account that the DBMS runs under. Don't run your DBMS as root or system! Most DBMSs run out of the box with a very powerful system account. For example, MySQL runs as system on Windows by default! Change the DBMS's OS account to something more appropriate, with restricted privileges.

=== Multiple DB Users ===

The designer of web applications should not only avoid using the same owner/admin account in the web applications to connect to the database. Different DB users could be used for different web applications. In general, each separate web application that requires access to the database could have a designated database user account that the web-app will use to connect to the DB. That way, the designer of the application can have good granularity in the access control, thus reducing the privileges as much as possible. Each DB user will then have select access to what it needs only, and write-access as needed.

As an example, a login page requires read access to the username and password fields of a table, but no write access of any form (no insert, update, or delete). However, the sign-up page certainly requires insert privilege to that table; this restriction can only be enforced if these web apps use different DB users to connect to the database.

=== Views ===

You can use SQL views to further increase the granularity of access by limiting the read access to specific fields of a table or joins of tables. It could potentially have additional benefits: for example, suppose that the system is required (perhaps due to some specific legal requirements) to store the passwords of the users, instead of salted-hashed passwords. The designer could use views to compensate for this limitation; revoke all access to the table (from all DB users except the owner/admin) and create a view that outputs the hash of the password field and not the field itself. Any SQL injection attack that succeeds in stealing DB information will be restricted to stealing the hash of the passwords (could even be a keyed hash), since no DB user for any of the web applications has access to the table itself.

== White List Input Validation ==

In addition to being a primary defense when nothing else is possible (e.g., when a bind variable isn't legal), input validation can also be a secondary defense used to detect unauthorized input before it is passed to the SQL query. For more information please see the [[Input Validation Cheat Sheet]]. Proceed with caution here. Validated data is not necessarily safe to insert into SQL queries via string building.
<br /><br />

=Related Articles=

'''SQL Injection Attack Cheat Sheets'''

The following articles describe how to exploit different kinds of SQL Injection Vulnerabilities on various platforms that this article was created to help you avoid:

* "SQL Injection Cheat Sheet" - http://ferruh.mavituna.com/sql-injection-cheatsheet-oku/
* "Bypassing WAF's with SQLi" - [[SQL Injection Bypassing WAF]]

'''Description of SQL Injection Vulnerabilities'''

* OWASP article on [[SQL Injection]] Vulnerabilities
* OWASP article on [[Blind_SQL_Injection]] Vulnerabilities

'''How to Avoid SQL Injection Vulnerabilities'''

* [[:Category:OWASP Guide Project|OWASP Developers Guide]] article on how to [[Guide to SQL Injection | Avoid SQL Injection]] Vulnerabilities
* OWASP Cheat Sheet that provides [[Query_Parameterization_Cheat_Sheet|numerous language specific examples of parameterized queries using both Prepared Statements and Stored Procedures]]
* [http://bobby-tables.com/ The Bobby Tables site (inspired by the XKCD webcomic) has numerous examples in different languages of parameterized Prepared Statements and Stored Procedures]

'''How to Review Code for SQL Injection Vulnerabilities'''

* [[:Category:OWASP Code Review Project|OWASP Code Review Guide]] article on how to [[Reviewing Code for SQL Injection|Review Code for SQL Injection]] Vulnerabilities

'''How to Test for SQL Injection Vulnerabilities'''

* [[:Category:OWASP Testing Project|OWASP Testing Guide]] article on how to [[Testing for SQL Injection (OWASP-DV-005)|Test for SQL Injection]] Vulnerabilities

<br /><br />

= Authors and Primary Editors =

[[User:wichers|Dave Wichers]] - dave.wichers[at]owasp.org<br />
[[User:jmanico|Jim Manico]] - jim[at]owasp.org<br />
Matt Seil - mseil[at]acm.org<br>
[https://owasp.org/index.php/Dhiraj_Mishra Dhiraj Mishra] - mishra.dhiraj[at]owasp.org

<br />
== Other Cheatsheets ==

{{Cheatsheet_Navigation_Body}}

[[Category:Cheatsheets]]
[[Category:Popular]]

SQL Injection Prevention Cheat Sheet

2017-07-19T15:38:52Z

AnnGrove: /* Defense Option 4: Escaping All User Supplied Input */ This page had a couple of bad links and some erosion from edits over time, such as the list at the top not including defense option 4.

__NOTOC__
<div style="width:100%;height:160px;border:0,margin:0;overflow: hidden;">[[File:Cheatsheets-header.jpg|link=]]</div>

Last revision (mm/dd/yy): '''{{REVISIONMONTH}}/{{REVISIONDAY}}/{{REVISIONYEAR}}'''
= Introduction =
__TOC__{{TOC hidden}}

This article is focused on providing clear, simple, actionable guidance for preventing SQL Injection flaws in your applications. [[SQL Injection]] attacks are unfortunately very common, and this is due to two factors:

# the significant prevalence of SQL Injection vulnerabilities, and
# the attractiveness of the target (i.e., the database typically contains all the interesting/critical data for your application).

It’s somewhat shameful that there are so many successful SQL Injection attacks occurring, because it is EXTREMELY simple to avoid SQL Injection vulnerabilities in your code.

SQL Injection flaws are introduced when software developers create dynamic database queries that include user supplied input. To avoid SQL injection flaws is simple. Developers need to either:
a) stop writing dynamic queries; and/or
b) prevent user supplied input which contains malicious SQL from affecting the logic of the executed query.

This article provides a set of simple techniques for preventing SQL Injection vulnerabilities by avoiding these two problems. These techniques can be used with practically any kind of programming language with any type of database. There are other types of databases, like XML databases, which can have similar problems (e.g., XPath and XQuery injection) and these techniques can be used to protect them as well.

Primary Defenses:
* '''Option 1: Use of Prepared Statements (with Parameterized Queries)'''
* '''Option 2: Use of Stored Procedures'''
* '''Option 3: White List Input Validation'''
* '''Option 4: Escaping All User Supplied Input'''

Additional Defenses:
* '''Also: Enforcing Least Privilege'''
* '''Also: Performing White List Input Validation as a Secondary Defense'''
<br>
;Unsafe Example

SQL injection flaws typically look like this:

The following (Java) example is UNSAFE, and would allow an attacker to inject code into the query that would be executed by the database. The unvalidated “customerName” parameter that is simply appended to the query allows an attacker to inject any SQL code they want. Unfortunately, this method for accessing databases is all too common.

String query = "SELECT account_balance FROM user_data WHERE user_name = "
+ request.getParameter("customerName");

try {
Statement statement = connection.createStatement( … );
ResultSet results = statement.executeQuery( query );
}

=Primary Defenses=

==Defense Option 1: Prepared Statements (with Parameterized Queries)==

The use of prepared statements with variable binding (aka parameterized queries) is how all developers should first be taught how to write database queries. They are simple to write, and easier to understand than dynamic queries. Parameterized queries force the developer to first define all the SQL code, and then pass in each parameter to the query later. This coding style allows the database to distinguish between code and data, regardless of what user input is supplied.

Prepared statements ensure that an attacker is not able to change the intent of a query, even if SQL commands are inserted by an attacker. In the safe example below, if an attacker were to enter the userID of tom' or '1'='1, the parameterized query would not be vulnerable and would instead look for a username which literally matched the entire string tom' or '1'='1.

Language specific recommendations:
* Java EE – use PreparedStatement() with bind variables
* .NET – use parameterized queries like SqlCommand() or OleDbCommand() with bind variables
* PHP – use PDO with strongly typed parameterized queries (using bindParam())
* Hibernate - use createQuery() with bind variables (called named parameters in Hibernate)
* SQLite - use sqlite3_prepare() to create a [http://www.sqlite.org/c3ref/stmt.html statement object]

In rare circumstances, prepared statements can harm performance. When confronted with this situation, it is best to either a) strongly validate all data or b) escape all user supplied input using an escaping routine specific to your database vendor as described below, rather than using a prepared statement.

;Safe Java Prepared Statement Example

The following code example uses a PreparedStatement, Java's implementation of a parameterized query, to execute the same database query.

String custname = request.getParameter("customerName"); // This should REALLY be validated too
// perform input validation to detect attacks
String query = "SELECT account_balance FROM user_data WHERE user_name = ? ";

'''PreparedStatement pstmt = connection.prepareStatement( query );'''
'''pstmt.setString( 1, custname); '''
ResultSet results = pstmt.executeQuery( );

;Safe C# .NET Prepared Statement Example

With .NET, it's even more straightforward. The creation and execution of the query doesn't change. All you have to do is simply pass the parameters to the query using the Parameters.Add() call as shown here.

String query =
"SELECT account_balance FROM user_data WHERE user_name = ?";
try {
OleDbCommand command = new OleDbCommand(query, connection);
'''command.Parameters.Add(new OleDbParameter("customerName", CustomerName Name.Text));'''
OleDbDataReader reader = command.ExecuteReader();
// …
} catch (OleDbException se) {
// error handling
}

We have shown examples in Java and .NET but practically all other languages, including Cold Fusion, and Classic ASP, support parameterized query interfaces. Even SQL abstraction layers, like the [http://www.hibernate.org/ Hibernate Query Language] (HQL) have the same type of injection problems (which we call [http://cwe.mitre.org/data/definitions/564.html HQL Injection]). HQL supports parameterized queries as well, so we can avoid this problem:

;Hibernate Query Language (HQL) Prepared Statement (Named Parameters) Examples

First is an unsafe HQL Statement

Query unsafeHQLQuery = session.createQuery("from Inventory where productID='"+userSuppliedParameter+"'");

Here is a safe version of the same query using named parameters

Query safeHQLQuery = session.createQuery("from Inventory where productID=:productid");
safeHQLQuery.setParameter("productid", userSuppliedParameter);

For examples of parameterized queries in other languages, including Ruby, PHP, Cold Fusion, and Perl, see the [[Query Parameterization Cheat Sheet]] or http://bobby-tables.com/.

Developers tend to like the Prepared Statement approach because all the SQL code stays within the application. This makes your application relatively database independent.

== Defense Option 2: Stored Procedures ==

Stored procedures are not always safe from SQL injection. However, certain standard stored procedure programming constructs have the same effect as the use of parameterized queries when implemented safely* which is the norm for most stored procedure languages. They require the developer to just build SQL statements with parameters which are automatically parameterized unless the developer does something largely out of the norm. The difference between prepared statements and stored procedures is that the SQL code for a stored procedure is defined and stored in the database itself, and then called from the application. Both of these techniques have the same effectiveness in preventing SQL injection so your organization should choose which approach makes the most sense for you.

*Note: 'Implemented safely' means the stored procedure does not include any unsafe dynamic SQL generation. Developers do not usually generate dynamic SQL inside stored procedures. However, it can be done, but should be avoided. If it can't be avoided, the stored procedure must use input validation or proper escaping as described in this article to make sure that all user supplied input to the stored procedure can't be used to inject SQL code into the dynamically generated query. Auditors should always look for uses of sp_execute, execute or exec within SQL Server stored procedures. Similar audit guidelines are necessary for similar functions for other vendors.

There are also several cases where stored procedures can increase risk. For example, on MS SQL server, you have 3 main default roles: db_datareader, db_datawriter and db_owner. Before stored procedures came into use, DBA's would give db_datareader or db_datawriter rights to the webservice's user, depending on the requirements. However, stored procedures require execute rights, a role that is not available by default. Some setups where the user management has been centralized, but is limited to those 3 roles, cause all web apps to run under db_owner rights so stored procedures can work. Naturally, that means that if a server is breached the attacker has full rights to the database, where previously they might only have had read-access. More on this topic here. http://www.sqldbatips.com/showarticle.asp?ID=8

;Safe Java Stored Procedure Example

The following code example uses a CallableStatement, Java's implementation of the stored procedure interface, to execute the same database query. The "sp_getAccountBalance" stored procedure would have to be predefined in the database and implement the same functionality as the query defined above.

String custname = request.getParameter("customerName"); // This should REALLY be validated
try {
'''CallableStatement cs = connection.prepareCall("{call sp_getAccountBalance(?)}");'''
'''cs.setString(1, custname);'''
ResultSet results = cs.executeQuery();
// … result set handling
} catch (SQLException se) {
// … logging and error handling
}

;Safe VB .NET Stored Procedure Example

The following code example uses a SqlCommand, .NET’s implementation of the stored procedure interface, to execute the same database query. The "sp_getAccountBalance" stored procedure would have to be predefined in the database and implement the same functionality as the query defined above.

Try
Dim command As SqlCommand = new SqlCommand("sp_getAccountBalance", connection)
'''command.CommandType = CommandType.StoredProcedure'''
'''command.Parameters.Add(new SqlParameter("@CustomerName", CustomerName.Text))'''
Dim reader As SqlDataReader = command.ExecuteReader()
‘ …
Catch se As SqlException
‘ error handling
End Try

== Defense Option 3: White List Input Validation ==

Various parts of SQL queries aren't legal locations for the use of bind variables, such as the names of tables or columns, and the sort order indicator (ASC or DESC). In such situations, input validation or query redesign is the most appropriate defense. For the names of tables or columns, ideally those values come from the code, and not from user parameters. But if user parameter values are used to make different for table names and column names, then the parameter values should be mapped to the legal/expected table or column names to make sure unvalidated user input doesn't end up in the query. Please note, this is a symptom of poor design and a full re-write should be considered if time allows. Here is an example of table name validation.

String tableName;
switch(PARAM):
case "Value1": tableName = "fooTable";
break;
case "Value2": tableName = "barTable";
break;
...
default : throw new InputValidationException("unexpected value provided for table name");

The tableName can then be directly appended to the SQL query since it is now known to be one of the legal and expected values for a table name in this query. Keep in mind that generic table validation functions can lead to data loss as table names are used in queries where they are not expected.

For something simple like a sort order, it would be best if the user supplied input is converted to a boolean, and then that boolean is used to select the safe value to append to the query. This is a very standard need in dynamic query creation. For example:

public String someMethod(boolean sortOrder) {

String SQLquery = "some SQL ... order by Salary " + (sortOrder ? "ASC" : "DESC");
...

Any time user input can be converted to a non-String, like a date, numeric, boolean, enumerated type, etc. before it is appended to a query, or used to select a value to append to the query, this ensures it is safe to do so.

Input validation is also recommended as a secondary defense in ALL cases, even when using bind variables as is discussed later in this article. More techniques on how to implement strong white list input validation is described in the [[Input Validation Cheat Sheet]].

==Defense Option 4: Escaping All User-Supplied Input==

This technique should only be used as a last resort, when none of the above are feasible. Input validation is probably a better choice as this methodology is frail compared to other defenses and we cannot guarantee it will prevent all SQL Injection in all situations.

This technique is to escape user input before putting it in a query. It is very database specific in its implementation. It's usually only recommended to retrofit legacy code when implementing input validation isn't cost effective. Applications built from scratch, or applications requiring low risk tolerance should be built or re-written using parameterized queries, stored procedures, or some kind of Object Relational Mapper (ORM) that builds your queries for you.

This technique works like this. Each DBMS supports one or more character escaping schemes specific to certain kinds of queries. If you then escape all user supplied input using the proper escaping scheme for the database you are using, the DBMS will not confuse that input with SQL code written by the developer, thus avoiding any possible SQL injection vulnerabilities.

The OWASP Enterprise Security API (ESAPI) is a free, open source, web application security control library that makes it easier for programmers to write lower-risk applications. The ESAPI libraries are designed to make it easier for programmers to retrofit security into existing applications. The ESAPI libraries also serve as a solid foundation for new development.

* Full details on [https://www.owasp.org/index.php/Category:OWASP_Enterprise_Security_API ESAPI are available here on OWASP].
* The javadoc for [http://www.javadoc.io/doc/org.owasp.esapi/esapi/2.1.0 ESAPI 2.x (Legacy) is available]. This code was migrated to GitHub in November 2014.
* Directly [http://code.google.com/p/owasp-esapi-java/source/browse/#svn/trunk/src/main/java/org/owasp/esapi browse the source for ESAPI for Java 2.x (Legacy) at GitHub], which is frequently helpful if the javadoc isn't perfectly clear.
* Directly [[Https://github.com/ESAPI/esapi-java|browse the source for ESAPI for Java 3.x (Active) at GitHub]].

To find the javadoc specifically for the database encoders, click on the ‘Codec’ class on the left hand side. There are lots of Codecs implemented. The two Database specific codecs are OracleCodec, and MySQLCodec.

Just click on their names in the ‘All Known Implementing Classes:’ at the top of the Interface Codec page.

At this time, ESAPI currently has database encoders for:
* Oracle
* MySQL (Both ANSI and native modes are supported)

Database encoders are forthcoming for:
* SQL Server
* PostgreSQL

If your database encoder is missing, please let us know.

===Database Specific Escaping Details===

If you want to build your own escaping routines, here are the escaping details for each of the databases that we have developed ESAPI Encoders for:
* Oracle
* SQL Server
* DB2
* SQLi in PHP

====Oracle Escaping====

This information is based on the Oracle Escape character information found here: http://www.orafaq.com/wiki/SQL_FAQ#How_does_one_escape_special_characters_when_writing_SQL_queries.3F

=====Escaping Dynamic Queries=====

To use an ESAPI database codec is pretty simple. An Oracle example looks something like:
ESAPI.encoder().encodeForSQL( new OracleCodec(), queryparam );

So, if you had an existing Dynamic query being generated in your code that was going to Oracle that looked like this:

String query = "SELECT user_id FROM user_data WHERE user_name = '" + req.getParameter("userID")
+ "' and user_password = '" + req.getParameter("pwd") +"'";
try {
Statement statement = connection.createStatement( … );
ResultSet results = statement.executeQuery( query );
}

You would rewrite the first line to look like this:

'''Codec ORACLE_CODEC = new OracleCodec();'''
String query = "SELECT user_id FROM user_data WHERE user_name = '" +
'''ESAPI.encoder().encodeForSQL( ORACLE_CODEC, req.getParameter("userID"))''' + "' and user_password = '"
+ '''ESAPI.encoder().encodeForSQL( ORACLE_CODEC, req.getParameter("pwd"))''' +"'";

And it would now be safe from SQL injection, regardless of the input supplied.

For maximum code readability, you could also construct your own OracleEncoder.

Encoder oe = new OracleEncoder();
String query = "SELECT user_id FROM user_data WHERE user_name = '"
+ '''oe.encode( req.getParameter("userID"))''' + "' and user_password = '"
+ '''oe.encode( req.getParameter("pwd"))''' +"'";

With this type of solution, you would need only to wrap each user-supplied parameter being passed into an '''ESAPI.encoder().encodeForOracle( )''' call or whatever you named the call and you would be done.

=====Turn off character replacement=====

Use SET DEFINE OFF or SET SCAN OFF to ensure that automatic character replacement is turned off. If this character replacement is turned on, the & character will be treated like a SQLPlus variable prefix that could allow an attacker to retrieve private data.

See http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12040.htm#i2698854 and http://stackoverflow.com/questions/152837/how-to-insert-a-string-which-contains-an for more information

=====Escaping Wildcard characters in Like Clauses=====

The LIKE keyword allows for text scanning searches. In Oracle, the underscore '_' character matches only one character, while the ampersand '%' is used to match zero or more occurrences of any characters. These characters must be escaped in LIKE clause criteria. For example:

SELECT name FROM emp
WHERE id LIKE '%/_%' ESCAPE '/';

SELECT name FROM emp
WHERE id LIKE '%\%%' ESCAPE '\';

=====Oracle 10g escaping=====

<nowiki>An alternative for Oracle 10g and later is to place { and } around the string to escape the entire string. However, you have to be careful that there isn't a } character already in the string. You must search for these and if there is one, then you must replace it with }}. Otherwise that character will end the escaping early, and may introduce a vulnerability.</nowiki>

====MySQL Escaping====

MySQL supports two escaping modes:

# ANSI_QUOTES SQL mode, and a mode with this off, which we call
# MySQL mode.

ANSI SQL mode: Simply encode all ' (single tick) characters with '' (two single ticks)

MySQL mode, do the following:

NUL (0x00) --> \0 [This is a zero, not the letter O]
BS (0x08) --> \b
TAB (0x09) --> \t
LF (0x0a) --> \n
CR (0x0d) --> \r
SUB (0x1a) --> \Z
" (0x22) --> \"
% (0x25) --> \%
' (0x27) --> \'
\ (0x5c) --> \\
_ (0x5f) --> \_
all other non-alphanumeric characters with ASCII values less than 256 --> \c
where 'c' is the original non-alphanumeric character.

This information is based on the MySQL Escape character information found here: http://mirror.yandex.ru/mirrors/ftp.mysql.com/doc/refman/5.0/en/string-syntax.html

====SQL Server Escaping====

We have not implemented the SQL Server escaping routine yet, but the following has good pointers and links to articles describing how to prevent SQL injection attacks on SQL server
* http://blogs.msdn.com/raulga/archive/2007/01/04/dynamic-sql-sql-injection.aspx

====DB2 Escaping====
This information is based on DB2 WebQuery special characters found here: https://www-304.ibm.com/support/docview.wss?uid=nas14488c61e3223e8a78625744f00782983
as well as some information from Oracle's JDBC DB2 driver found here:
http://docs.oracle.com/cd/E12840_01/wls/docs103/jdbc_drivers/sqlescape.html

Information in regards to differences between several DB2 Universal drivers can be found here: http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/rjvjcsqc.htm

===Hex-encoding all input===

A somewhat special case of escaping is the process of hex-encode the entire string received from the user (this can be seen as escaping every character). The web application should hex-encode the user input before including it in the SQL statement. The SQL statement should take into account this fact, and accordingly compare the data. For example, if we have to look up a record matching a sessionID, and the user transmitted the string abc123 as the session ID, the select statement would be:

SELECT ... FROM session
WHERE hex_encode (sessionID) = '616263313233'

(hex_encode should be replaced by the particular facility for the database being used.) The string 606162313233 is the hex encoded version of the string received from the user (it is the sequence of hex values of the ASCII/UTF-8 codes of the user data).

If an attacker were to transmit a string containing a single-quote character followed by their attempt to inject SQL code, the constructed SQL statement will only look like:

WHERE hex_encode ( ... ) = '2720 ... '

27 being the ASCII code (in hex) of the single-quote, which is simply hex-encoded like any other character in the string. The resulting SQL can only contain numeric digits and letters a to f, and never any special character that could enable an SQL injection.

===Escaping SQLi in PHP===

Use prepared statements and parameterized queries. These are SQL statements that are sent to and parsed by the database server separately from any parameters. This way it is impossible for an attacker to inject malicious SQL.

<br>You basically have two options to achieve this:<br>

1. Using [http://php.net/manual/en/book.pdo.php PDO] (for any supported database driver):
<pre>
$stmt = $pdo->prepare('SELECT * FROM employees WHERE name = :name');

$stmt->execute(array('name' => $name));

foreach ($stmt as $row) {
// do something with $row
}
</pre>
2. Using [http://php.net/manual/en/book.mysqli.php MySQLi] (for MySQL):
<pre>
$stmt = $dbConnection->prepare('SELECT * FROM employees WHERE name = ?');
$stmt->bind_param('s', $name);

$stmt->execute();

$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
// do something with $row
}
</pre>
PDO is the universal option. If you're connecting to a database other than MySQL, you can refer to a driver-specific second option (e.g. pg_prepare() and pg_execute() for PostgreSQL).

= Additional Defenses =

Beyond adopting one of the four primary defenses, we also recommend adopting all of these additional defenses in order to provide defense in depth. These additional defenses are:

* '''Least Privilege'''
* '''White List Input Validation'''

== Least Privilege ==

To minimize the potential damage of a successful SQL injection attack, you should minimize the privileges assigned to every database account in your environment. Do not assign DBA or admin type access rights to your application accounts. We understand that this is easy, and everything just ‘works’ when you do it this way, but it is very dangerous. Start from the ground up to determine what access rights your application accounts require, rather than trying to figure out what access rights you need to take away. Make sure that accounts that only need read access are only granted read access to the tables they need access to. If an account only needs access to portions of a table, consider creating a view that limits access to that portion of the data and assigning the account access to the view instead, rather than the underlying table. Rarely, if ever, grant create or delete access to database accounts.

If you adopt a policy where you use stored procedures everywhere, and don’t allow application accounts to directly execute their own queries, then restrict those accounts to only be able to execute the stored procedures they need. Don’t grant them any rights directly to the tables in the database.

SQL injection is not the only threat to your database data. Attackers can simply change the parameter values from one of the legal values they are presented with, to a value that is unauthorized for them, but the application itself might be authorized to access. As such, minimizing the privileges granted to your application will reduce the likelihood of such unauthorized access attempts, even when an attacker is not trying to use SQL injection as part of their exploit.

While you are at it, you should minimize the privileges of the operating system account that the DBMS runs under. Don't run your DBMS as root or system! Most DBMSs run out of the box with a very powerful system account. For example, MySQL runs as system on Windows by default! Change the DBMS's OS account to something more appropriate, with restricted privileges.

=== Multiple DB Users ===

The designer of web applications should not only avoid using the same owner/admin account in the web applications to connect to the database. Different DB users could be used for different web applications. In general, each separate web application that requires access to the database could have a designated database user account that the web-app will use to connect to the DB. That way, the designer of the application can have good granularity in the access control, thus reducing the privileges as much as possible. Each DB user will then have select access to what it needs only, and write-access as needed.

As an example, a login page requires read access to the username and password fields of a table, but no write access of any form (no insert, update, or delete). However, the sign-up page certainly requires insert privilege to that table; this restriction can only be enforced if these web apps use different DB users to connect to the database.

=== Views ===

You can use SQL views to further increase the granularity of access by limiting the read access to specific fields of a table or joins of tables. It could potentially have additional benefits: for example, suppose that the system is required (perhaps due to some specific legal requirements) to store the passwords of the users, instead of salted-hashed passwords. The designer could use views to compensate for this limitation; revoke all access to the table (from all DB users except the owner/admin) and create a view that outputs the hash of the password field and not the field itself. Any SQL injection attack that succeeds in stealing DB information will be restricted to stealing the hash of the passwords (could even be a keyed hash), since no DB user for any of the web applications has access to the table itself.

== White List Input Validation ==

In addition to being a primary defense when nothing else is possible (e.g., when a bind variable isn't legal), input validation can also be a secondary defense used to detect unauthorized input before it is passed to the SQL query. For more information please see the [[Input Validation Cheat Sheet]]. Proceed with caution here. Validated data is not necessarily safe to insert into SQL queries via string building.
<br /><br />

=Related Articles=

'''SQL Injection Attack Cheat Sheets'''

The following articles describe how to exploit different kinds of SQL Injection Vulnerabilities on various platforms that this article was created to help you avoid:

* "SQL Injection Cheat Sheet" - http://ferruh.mavituna.com/sql-injection-cheatsheet-oku/
* "Bypassing WAF's with SQLi" - [[SQL Injection Bypassing WAF]]

'''Description of SQL Injection Vulnerabilities'''

* OWASP article on [[SQL Injection]] Vulnerabilities
* OWASP article on [[Blind_SQL_Injection]] Vulnerabilities

'''How to Avoid SQL Injection Vulnerabilities'''

* [[:Category:OWASP Guide Project|OWASP Developers Guide]] article on how to [[Guide to SQL Injection | Avoid SQL Injection]] Vulnerabilities
* OWASP Cheat Sheet that provides [[Query_Parameterization_Cheat_Sheet|numerous language specific examples of parameterized queries using both Prepared Statements and Stored Procedures]]
* [http://bobby-tables.com/ The Bobby Tables site (inspired by the XKCD webcomic) has numerous examples in different languages of parameterized Prepared Statements and Stored Procedures]

'''How to Review Code for SQL Injection Vulnerabilities'''

* [[:Category:OWASP Code Review Project|OWASP Code Review Guide]] article on how to [[Reviewing Code for SQL Injection|Review Code for SQL Injection]] Vulnerabilities

'''How to Test for SQL Injection Vulnerabilities'''

* [[:Category:OWASP Testing Project|OWASP Testing Guide]] article on how to [[Testing for SQL Injection (OWASP-DV-005)|Test for SQL Injection]] Vulnerabilities

<br /><br />

= Authors and Primary Editors =

[[User:wichers|Dave Wichers]] - dave.wichers[at]owasp.org<br />
[[User:jmanico|Jim Manico]] - jim[at]owasp.org<br />
Matt Seil - mseil[at]acm.org<br>
[https://owasp.org/index.php/Dhiraj_Mishra Dhiraj Mishra] - mishra.dhiraj[at]owasp.org

<br />
== Other Cheatsheets ==

{{Cheatsheet_Navigation_Body}}

[[Category:Cheatsheets]]
[[Category:Popular]]

Baltimore

2017-07-11T23:26:39Z

AnnGrove: /* Again, Welcome! */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

== Social Channels ==
Let's stay connected!

Meetup: https://www.meetup.com/dc3782c2-4995-4ba5-b551-1d24eb7583ac/

LinkedIn: https://www.linkedin.com/groups/4879966/profile

Twitter: @BaltimoreOWASP (https://twitter.com/BaltimoreOWASP)

Mailing list: https://lists.owasp.org/mailman/listinfo/owasp-baltimore

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email our leaders. Membership is not required to participate.

As already mentioned, meetings are FREE and OPEN to all interested parties.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [https://www.owasp.org/index.php/User:Chaim_sanders Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us with questions or interest in sponsorship, speaking, or offering space. We welcome your participation and thoughts.

Considering becoming a leader or volunteer? Prior to participating, please review the Chapter_Leader_Handbook.

The chapter is fiscally sound. Our current account balance can be publicly viewed, in the interest of transparency and accountability: https://docs.google.com/spreadsheets/d/11acTOmtmBGq6-5CIGsjlEByU8POSGqda0r23VNnhEGQ/pub?hl=en_US&hl=en_US&hl=en_US&output=html

The group's mailing list, [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], is open to both members and non-members and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes both email address and the message body.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon (posted July 2017)
|TBD
|
|-
| Dec 5, 2013 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7, 2013 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3, 2013 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11, 2013 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6, 2013 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2, 2013 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4, 2013 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Again, Welcome! ==

Everyone -- whether a member or not -- is welcome to join our mailing list, attend chapter meetings, and reach out to chapter leaders. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T23:20:52Z

AnnGrove: /* Local News */

Baltimore

2017-07-11T23:19:26Z

AnnGrove: /* Social Channels */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

== Social Channels ==
Let's stay connected!

Meetup: https://www.meetup.com/dc3782c2-4995-4ba5-b551-1d24eb7583ac/

LinkedIn: https://www.linkedin.com/groups/4879966/profile

Twitter: @BaltimoreOWASP (https://twitter.com/BaltimoreOWASP)

Mailing list: https://lists.owasp.org/mailman/listinfo/owasp-baltimore

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email our leaders. Membership is not required to participate.

As already mentioned, meetings are FREE and OPEN to all interested parties.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [https://www.owasp.org/index.php/User:Chaim_sanders Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us with questions or interest in sponsorship, speaking, or offering space. We welcome your participation and thoughts.

Considering becoming a leader or volunteer? Prior to participating, please review the Chapter_Leader_Handbook.

The chapter is fiscally sound. Our current account balance can be publicly viewed, in the interest of transparency and accountability: https://docs.google.com/spreadsheets/d/11acTOmtmBGq6-5CIGsjlEByU8POSGqda0r23VNnhEGQ/pub?hl=en_US&hl=en_US&hl=en_US&output=html

The group's mailing list, [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], is open to both members and non-members and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes both email address and the message body.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon (posted July 2017)
|TBD
|
|-
| Dec 5, 2013 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7, 2013 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3, 2013 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11, 2013 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6, 2013 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2, 2013 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4, 2013 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you have a question or are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts!

Everyone -- whether a member or not -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T23:17:10Z

AnnGrove: /* Social Channels */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

== Social Channels ==
Let's stay connected!

Meetup: https://www.meetup.com/dc3782c2-4995-4ba5-b551-1d24eb7583ac/

LinkedIn: https://www.linkedin.com/groups/4879966/profile

Twitter: @BaltimoreOWASP (https://twitter.com/BaltimoreOWASP)

Mailing list: https://lists.owasp.org/mailman/listinfo/owasp-baltimore

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email our leaders. Membership is not required to participate.

As already mentioned, meetings are FREE and OPEN to all interested parties.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [https://www.owasp.org/index.php/User:Chaim_sanders Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us with questions or interest in sponsorship, speaking, or offering space. We welcome your participation and thoughts.

Considering becoming a leader or volunteer? Prior to participating, please review the Chapter_Leader_Handbook.

The chapter is fiscally sound. Our current account balance can be publicly viewed, in the interest of transparency and accountability.

The group's mailing list, [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], is open to both members and non-members and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes both email address and the message body.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon (posted July 2017)
|TBD
|
|-
| Dec 5, 2013 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7, 2013 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3, 2013 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11, 2013 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6, 2013 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2, 2013 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4, 2013 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you have a question or are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts!

Everyone -- whether a member or not -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T23:15:12Z

AnnGrove: /* Welcome to OWASP Baltimore */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

== Social Channels ==
Let's stay connected!

Meetup: https://www.meetup.com/dc3782c2-4995-4ba5-b551-1d24eb7583ac/

LinkedIn: https://www.linkedin.com/groups/4879966/profile

Twitter: @BaltimoreOWASP (https://twitter.com/BaltimoreOWASP)

Mailing list: https://lists.owasp.org/mailman/listinfo/owasp-baltimore

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email our leaders. Membership is not required to participate.

As already mentioned, meetings are FREE and OPEN to all interested parties.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [https://www.owasp.org/index.php/User:Chaim_sanders Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us with questions or interest in sponsorship, speaking, or offering space. We welcome your participation and thoughts.

The group's mailing list, [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], is open to both members and non-members and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes both email address and the message body.

Chapter volunteers: prior to participating with OWASP, please review the Chapter_Leader_Handbook.

The chapter is fiscally sound. Our current account balance can be publicly viewed, in the interest of transparency.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon (posted July 2017)
|TBD
|
|-
| Dec 5, 2013 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7, 2013 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3, 2013 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11, 2013 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6, 2013 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2, 2013 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4, 2013 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you have a question or are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts!

Everyone -- whether a member or not -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T23:12:26Z

AnnGrove: /* Welcome to OWASP Baltimore */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

Chapter volunteers: prior to participating with OWASP, please review the [[Chapter_Leader_Handbook]].

The chapter is fiscally sound. Our current account balance can be [https://docs.google.com/spreadsheets/d/11acTOmtmBGq6-5CIGsjlEByU8POSGqda0r23VNnhEGQ/pub?hl=en_US&hl=en_US&hl=en_US&output=html publicly viewed], in the interest of transparency.

== Social Channels ==
Let's stay connected!

Meetup: https://www.meetup.com/dc3782c2-4995-4ba5-b551-1d24eb7583ac/

LinkedIn: https://www.linkedin.com/groups/4879966/profile

Twitter: @BaltimoreOWASP (https://twitter.com/BaltimoreOWASP)

Mailing list: https://lists.owasp.org/mailman/listinfo/owasp-baltimore

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email our leaders. Membership is not required to participate.

As already mentioned, meetings are FREE and OPEN to all interested parties.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [https://www.owasp.org/index.php/User:Chaim_sanders Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us with questions or interest in sponsorship, speaking, or offering space. We welcome your participation and thoughts.

The group's mailing list, [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], is open to both members and non-members and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes both email address and the message body.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon (posted July 2017)
|TBD
|
|-
| Dec 5, 2013 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7, 2013 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3, 2013 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11, 2013 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6, 2013 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2, 2013 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4, 2013 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you have a question or are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts!

Everyone -- whether a member or not -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T23:10:25Z

AnnGrove: /* Welcome to OWASP Baltimore */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

Chapter volunteers: prior to participating with OWASP, please review the [[Chapter_Leader_Handbook]].

The chapter is fiscally sound. Our current account balance can be [https://docs.google.com/spreadsheets/d/11acTOmtmBGq6-5CIGsjlEByU8POSGqda0r23VNnhEGQ/pub?hl=en_US&hl=en_US&hl=en_US&output=html publicly viewed], in the interest of transparency.

== Social Channels ==
Let's stay connected!

Meetup: https://www.meetup.com/dc3782c2-4995-4ba5-b551-1d24eb7583ac/

LinkedIn: https://www.linkedin.com/groups/4879966/profile

Twitter: @BaltimoreOWASP (https://twitter.com/BaltimoreOWASP)

Mailing list: https://lists.owasp.org/mailman/listinfo/owasp-baltimore

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email our leaders. Membership is not required to participate.

As already mentioned, meetings are FREE and OPEN to all interested parties.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [https://www.owasp.org/index.php/User:Chaim_sanders Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us. The chapter leaders and mailing list welcome your participation and thoughts.

The group's mailing list, [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], is open to both members and non-members and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes both email address and the message body.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon (posted July 2017)
|TBD
|
|-
| Dec 5, 2013 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7, 2013 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3, 2013 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11, 2013 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6, 2013 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2, 2013 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4, 2013 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you have a question or are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts!

Everyone -- whether a member or not -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T23:09:59Z

AnnGrove: /* Social Channels */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

Chapter volunteers, prior to participating with OWASP, please review the [[Chapter_Leader_Handbook]].

The chapter is fiscally sound. Our current account balance can be [https://docs.google.com/spreadsheets/d/11acTOmtmBGq6-5CIGsjlEByU8POSGqda0r23VNnhEGQ/pub?hl=en_US&hl=en_US&hl=en_US&output=html publicly viewed], in the interest of transparency.

== Social Channels ==
Let's stay connected!

Meetup: https://www.meetup.com/dc3782c2-4995-4ba5-b551-1d24eb7583ac/

LinkedIn: https://www.linkedin.com/groups/4879966/profile

Twitter: @BaltimoreOWASP (https://twitter.com/BaltimoreOWASP)

Mailing list: https://lists.owasp.org/mailman/listinfo/owasp-baltimore

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email our leaders. Membership is not required to participate.

As already mentioned, meetings are FREE and OPEN to all interested parties.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [https://www.owasp.org/index.php/User:Chaim_sanders Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us. The chapter leaders and mailing list welcome your participation and thoughts.

The group's mailing list, [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], is open to both members and non-members and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes both email address and the message body.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon (posted July 2017)
|TBD
|
|-
| Dec 5, 2013 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7, 2013 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3, 2013 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11, 2013 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6, 2013 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2, 2013 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4, 2013 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you have a question or are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts!

Everyone -- whether a member or not -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T23:08:16Z

AnnGrove: /* Recent Meetings */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

Chapter volunteers, prior to participating with OWASP, please review the [[Chapter_Leader_Handbook]].

The chapter is fiscally sound. Our current account balance can be [https://docs.google.com/spreadsheets/d/11acTOmtmBGq6-5CIGsjlEByU8POSGqda0r23VNnhEGQ/pub?hl=en_US&hl=en_US&hl=en_US&output=html publicly viewed], in the interest of transparency.

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email our leaders. Membership is not required to participate.

As already mentioned, meetings are FREE and OPEN to all interested parties.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [https://www.owasp.org/index.php/User:Chaim_sanders Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us. The chapter leaders and mailing list welcome your participation and thoughts.

The group's mailing list, [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], is open to both members and non-members and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes both email address and the message body.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon (posted July 2017)
|TBD
|
|-
| Dec 5, 2013 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7, 2013 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3, 2013 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11, 2013 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6, 2013 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2, 2013 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4, 2013 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Social Channels ==
Meetup: https://www.meetup.com/dc3782c2-4995-4ba5-b551-1d24eb7583ac/

LinkedIn: https://www.linkedin.com/groups/4879966/profile

Twitter: @BaltimoreOWASP (https://twitter.com/BaltimoreOWASP)

Mailing list: https://lists.owasp.org/mailman/listinfo/owasp-baltimore

== Local News ==

The chapter leaders are interested in hearing from you if you have a question or are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts!

Everyone -- whether a member or not -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T22:56:45Z

AnnGrove: /* Recent Meetings */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

Chapter volunteers, prior to participating with OWASP, please review the [[Chapter_Leader_Handbook]].

The chapter is fiscally sound. Our current account balance can be [https://docs.google.com/spreadsheets/d/11acTOmtmBGq6-5CIGsjlEByU8POSGqda0r23VNnhEGQ/pub?hl=en_US&hl=en_US&hl=en_US&output=html publicly viewed], in the interest of transparency.

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email our leaders. Membership is not required to participate.

As already mentioned, meetings are FREE and OPEN to all interested parties.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us. The chapter leaders and mailing list welcome your participation and thoughts.

The group's mailing list, [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], is open to both members and non-members and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes both email address and the message body.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon
|TBD
|
|-
| Dec 5, 2013 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7, 2013 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3, 2013 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts!

Everyone -- whether a member or not -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T22:53:42Z

AnnGrove: /* Recent Meetings */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

Chapter volunteers, prior to participating with OWASP, please review the [[Chapter_Leader_Handbook]].

The chapter is fiscally sound. Our current account balance can be [https://docs.google.com/spreadsheets/d/11acTOmtmBGq6-5CIGsjlEByU8POSGqda0r23VNnhEGQ/pub?hl=en_US&hl=en_US&hl=en_US&output=html publicly viewed], in the interest of transparency.

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email our leaders. Membership is not required to participate.

As already mentioned, meetings are FREE and OPEN to all interested parties.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us. The chapter leaders and mailing list welcome your participation and thoughts.

The group's mailing list, [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], is open to both members and non-members and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes both email address and the message body.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon
|TBD
|
|-
| Dec 5, 2013 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts!

Everyone -- whether a member or not -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T20:40:56Z

AnnGrove: /* Welcome to OWASP Baltimore */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

Chapter volunteers, prior to participating with OWASP, please review the [[Chapter_Leader_Handbook]].

The chapter is fiscally sound. Our current account balance can be [https://docs.google.com/spreadsheets/d/11acTOmtmBGq6-5CIGsjlEByU8POSGqda0r23VNnhEGQ/pub?hl=en_US&hl=en_US&hl=en_US&output=html publicly viewed], in the interest of transparency.

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email our leaders. Membership is not required to participate.

As already mentioned, meetings are FREE and OPEN to all interested parties.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us. The chapter leaders and mailing list welcome your participation and thoughts.

The group's mailing list, [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], is open to both members and non-members and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes both email address and the message body.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon
|TBD
|
|-
| Dec 5 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts!

Everyone -- whether a member or not -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T20:15:57Z

AnnGrove: /* Welcome to OWASP Baltimore */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

Chapter volunteers, prior to participating with OWASP, please review the [[Chapter_Leader_Handbook]].

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email our leaders. Membership is not required to participate.

As already mentioned, meetings are FREE and OPEN to all interested parties.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us. The chapter leaders and mailing list welcome your participation and thoughts.

The group's mailing list, [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], is open to both members and non-members and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes both email address and the message body.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon
|TBD
|
|-
| Dec 5 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts!

Everyone -- whether a member or not -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T20:13:51Z

AnnGrove: /* Welcome to OWASP Baltimore */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

Chapter volunteers, prior to participating with OWASP, please review the [[Chapter_Leader_Handbook]].

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email our leaders.

As already mentioned, meetings are FREE and OPEN to all interested parties.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us. The chapter leaders and mailing list welcome your participation and thoughts.

The group's mailing list, [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], is open to both members and non-members and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes both email address and the message body.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon
|TBD
|
|-
| Dec 5 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts!

Everyone -- whether a member or not -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T20:12:27Z

AnnGrove: /* Welcome to OWASP Baltimore */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

Chapter volunteers, prior to participating with OWASP, please review the [[Chapter_Leader_Handbook]].

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email our leaders.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us. The chapter leaders and mailing list welcome your participation and thoughts.

The group's mailing list, [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], is open to both members and non-members and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes both email address and the message body.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon
|TBD
|
|-
| Dec 5 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts!

Everyone -- whether a member or not -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T20:10:12Z

AnnGrove: /* Local News */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

Chapter volunteers, prior to participating with OWASP, please review the [[Chapter_Leader_Handbook]].

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email us directly.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us. The chapter leaders and mailing list welcome your participation and thoughts.

The group's mailing list is [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes both email address and the message body.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon
|TBD
|
|-
| Dec 5 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts!

Everyone -- whether a member or not -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T20:08:28Z

AnnGrove: /* Welcome to OWASP Baltimore */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

Chapter volunteers, prior to participating with OWASP, please review the [[Chapter_Leader_Handbook]].

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email us directly.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us. The chapter leaders and mailing list welcome your participation and thoughts.

The group's mailing list is [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes both email address and the message body.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon
|TBD
|
|-
| Dec 5 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts! Everyone -- whether a member or non-member -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T20:07:46Z

AnnGrove: /* Welcome to OWASP Baltimore */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, we encourage donations of meeting space, catering, and event sponsorship. Simply contact the local chapter leaders listed on this page to discuss.

Chapter volunteers, prior to participating with OWASP, please review the [[Chapter_Leader_Handbook]].

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email us directly.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us. The chapter leaders and mailing list welcome your participation and thoughts.

The group's mailing list is [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives]. Please be aware that communication sent to this list are publicly visible at the archive link. This includes email addresses and the message body.|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon
|TBD
|
|-
| Dec 5 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts! Everyone -- whether a member or non-member -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T20:04:08Z

AnnGrove: tweaks

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, donations of meeting space or refreshments sponsorship is encouraged. Simply contact the local chapter leaders listed on this page to discuss.

Chapter volunteers, prior to participating with OWASP, please review the [[Chapter_Leader_Handbook]].

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email us directly.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us. The chapter leaders and mailing list welcome your participation and thoughts.

The group's mailing list is [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives].|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon
|TBD
|
|-
| Dec 5 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts! Everyone -- whether a member or non-member -- is welcome to join our mailing list and attend chapter meetings. Join us as we pursue the OWASP mission: to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T20:00:12Z

AnnGrove: /* Welcome */

= Welcome to OWASP Baltimore =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

We encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, donations of meeting space or refreshments sponsorship is encouraged. Simply contact the local chapter leaders listed on this page to discuss.

Chapter volunteers, prior to participating with OWASP, please review the [[Chapter_Leader_Handbook]].

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email us directly.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us. The chapter leaders and mailing list welcome your participation and thoughts.

The group's mailing list is [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives].|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon
|TBD
|
|-
| Dec 5 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts! Everyone -- whether a member or non-member -- is welcome to join our mailing list and chapter meetings in pursuit of the OWASP mission to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]

Baltimore

2017-07-11T19:56:16Z

AnnGrove: minor edits

= Welcome =

The '''OWASP Baltimore Local Chapter''' meetings are FREE and OPEN to anyone interested in learning more about application security. We encourage individuals to provide knowledge transfer via hands-on training and presentations about OWASP projects, security research topics, and the Software Development Life Cycle.

We the encourage vendor-agnostic presentations and individual volunteerism to enable perpetual growth. As a 501(3)c non-profit association, donations of meeting space or refreshments sponsorship is encouraged. Simply contact the local chapter leaders listed on this page to discuss. Prior to participating with OWASP, please review the Chapter Handbook.

The chapter is committed to providing an engaging experience for a variety of audience types ranging from local students and those beginning in AppSec to experienced and accomplished professionals and researchers who are looking for competent collaborators for active OWASP-related projects.

{{Chapter Template|chaptername=Baltimore|extra =Come see us at a chapter meeting, join the mailing list, or email us directly.

The chapter leaders are [mailto:Ann.Grove@OWASP.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer]. Please feel free to email one or all of us. The chapter leaders and mailing list welcome your participation and thoughts.

The group's mailing list is [http://lists.owasp.org/mailman/listinfo/owasp-baltimore OWASP Baltimore], and its archive can be found at [http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives].|mailinglistsite=http://lists.owasp.org/mailman/listinfo/owasp-baltimore|emailarchives=http://lists.owasp.org/pipermail/owasp-baltimore OWASP Baltimore Archives}}

== Recent Meetings ==

{| class="wikitable"
|-
! Date !! Location !! Topic !! Speaker !! More
|-
|TBD
|TBD
|Meeting coming soon
|TBD
|
|-
| Dec 5 || Zot Inc. || AppSec at DevOps Speed and Portfolio Scale|| Jeff Williams || [http://www.youtube.com/watch?v=cIvOth0fxmI Slides]
|-
| Nov 7 || Unallocated Space || OWASP BWA & ZAP|| Chuck Willis || [https://www.owasp.org/images/5/56/OWASP_Baltimore_-_November_7th_BWA_and_ZAP_Slides.pdf Slides]
|-
| Sept 3 || Zot Inc. || OWASP ASVS || Dave Wichers || [https://www.owasp.org/index.php/File:OWASP_Baltimore_-_September_3rd_ASVS_WebApp_Standard_2013.ppt Slides]
|-
| July 11 || Unallocated Space || Pen Testing Lab + CTF Exercise || Brian || -
|-
| June 6 || Aspect Security || Good Component Practice || Ryan Berg || [https://www.owasp.org/images/4/4c/OWASP_Baltimore_-_June_6th_%3D_Good_Component_Practice.pdf Slides]
|-
| May 2 || SourceFire Inc. || Certificate & Public Key Pinning || Jeffrey Walton || [https://www.owasp.org/images/9/90/OWASP_Baltimore_-_May_2nd_%3D_Securing_Wireless_Channels.ppt Slides]
|-
| Apr 4 || SourceFire Inc. || Meet & Greet / OWASP Overview || Shawn Webb || -
|}
== Local News ==

The chapter leaders are interested in hearing from you if you are interested in sponsoring, offering a meeting space, or speaking. Please contact any or all of us if interested: [mailto:ann.grove@owasp.org Ann Grove], [mailto:Chaim.Sanders@OWASP.org Chaim Sanders], and [mailto:Brad.Scherer@OWASP.org Brad Scherer].

We are also in a drive for membership. If you know someone with an interest in application security, be sure to pass on the chapter contacts! Everyone -- whether a member or non-member -- is welcome to join our mailing list and chapter meetings in pursuit of the OWASP mission to make application security visible.

[[Category:OWASP Chapter]]
[[Category:Maryland]]