JavaScript is not currently enabled, but is required for full CodeSonar manual search and browse functionality.
If you are viewing this file in your hub's Web GUI, enable JavaScript in your browser: you will also need it for GUI functionality.
If you opened this file directly from disk, your browser may be directly suppressing JavaScript functionality: certain browsers perform this suppression on local files (but not files delivered by web servers) for security reasons.
| CodeSonar® 9.2p0 | CONFIDENTIAL | CodeSecure Inc |
Potentially-tainted data is used to construct an SQL query.
| Class Name | SQL Injection | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Significance | security | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Mnemonic | IO.INJ.SQL | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Categories |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Availability | Available for C and C++. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Enabling | Checks for this warning class are enabled by
default. To disable them, add the following WARNING_FILTER rule to the
project configuration file.
WARNING_FILTER += discard class="SQL Injection" |
Japanese (ja)
#include <stdio.h>
#include <sql.h>
RETCODE lookup_by_email (SQLHSTMT hstmt){
int querylen;
SQLCHAR query[256];
char useremail[128];
printf("Enter your email address.");
if (!fgets(useremail, 64, stdin)) return SQL_ERROR;
querylen = sprintf((char*)query,
"SELECT * FROM userinfo WHERE email = %s",
useremail);
return SQLExecDirect(hstmt, query, querylen); /* 'SQL Injection' warning issued here */
}
CodeSonar ships with library models that allow it to recognize functions such as libpq PQexec() and Win32 SQLPrepareA() that use one or more of their parameters to construct an SQL query. If one of these functions is called with a tainted value in one of those parameter positions, a warning will be issued.
If you have created a custom library model for some function f() in terms of one of these existing models, calls to f() will also be capable of triggering SQL Injection warnings.
The following configuration file parameters affect checks for this warning class.
To report problems with this documentation, please visit https://support.codesecure.com/.