Re: Protection from SQL injection - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Protection from SQL injection
Date
Msg-id 200804291139.09593.josh@agliodbs.com
Whole thread Raw
In response to Re: Protection from SQL injection  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Protection from SQL injection  (PFC <lists@peufeu.com>)
List pgsql-hackers
> If you're going to ask people to do significant revision of their
> apps to gain security, they're going to want it to work no matter
> what database they run their apps against.  This is why you need
> a client-side solution such as tainting.

Or if people are going to re-write their applications anyway, we'd want at
least a theoretically robust and flexible approach like libdejector, which
lets you identify which parts of a query structure are modifiable and
which are not.

For example, some applications need to replace whole phrases:

$criteria = "WHERE $var1 = '$var2'"

This is a very common approach for dynamic search screens, and really not
covered by placeholder approaches.

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Protection from SQL injection
Next
From: PFC
Date:
Subject: Re: Protection from SQL injection