8000 gh-96250: Improve sqlite3 injection attack example by jiajunjie · Pull Request #99270 · python/cpython · GitHub
[go: up one dir, main page]
Skip to content

gh-96250: Improve sqlite3 injection attack example #99270

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 6 commits into from
Dec 8, 2022
Merged

gh-96250: Improve sqlite3 injection attack example #99270

Changes from 1 commit
Commits
Show all changes
6 commits
Select commit Hold shift + click to select a range
867b98e
Improve sqlite3 injection attack example
jiajunjie Nov 9, 2022
5449ef5
Reflow bco. 79 char limit
erlend-aasland Nov 9, 2022
313a921
Use simulated REPL
jiajunjie Nov 16, 2022
41c5a82
Explain the example in the text
jiajunjie Nov 25, 2022
e622ccb
Explain the attack mechanism
jiajunjie Nov 29, 2022
c3fdb06
Add the attack effect
jiajunjie Dec 1, 2022
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Next Next commit
Improve sqlite3 injection attack example
  • Loading branch information
@jiajunjie
jiajunjie authored Nov 9, 2022
commit 867b98e84d445db4b1affb0ddeacda2ef3efe16a
5 changes: 4 additions & 1 deletion Doc/library/sqlite3.rst
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -1872,7 +1872,10 @@ are vulnerable to `SQL injection attacks`_ (see the `xkcd webcomic
<https://xkcd.com/327/>`_ for a humorous example of what can go wrong)::

# Never do this -- insecure!
symbol = 'RHAT'
# An attacker can select all stocks by entering "' OR 1 = 1; --", or load any
# extension by entering "' OR load_extension('./any.so'); --" when extension
# loading is enabled.
symbol = input()
cur.execute("SELECT * FROM stocks WHERE symbol = '%s'" % symbol)

Instead, use the DB-API's parameter substitution. To insert a variable into a
Expand Down
0