]> granicus.if.org Git - postgresql/commit
Sometimes the third time is the charm. Third try to fix the sql injection
authorBarry Lind <barry@xythos.com>
Thu, 7 Aug 2003 04:03:13 +0000 (04:03 +0000)
committerBarry Lind <barry@xythos.com>
Thu, 7 Aug 2003 04:03:13 +0000 (04:03 +0000)
commitacf09c64b0264715a4e29d3e04b5ca274350765a
tree74b4f7931d00aec6bb339611b6644f0bb06c5e80
parentf0f137599ae5af43f15363f921744bd3c2361966
Sometimes the third time is the charm.  Third try to fix the sql injection
vulnerability.  This fix completely removes the ability (hack) of being able
to bind a list of values in an in clause.  It was demonstrated that by allowing
that functionality you open up the possibility for certain types of
sql injection attacks.  The previous fix attempts all focused on preventing
the insertion of additional sql statements (the semi-colon problem:
xxx; any new sql statement here).  But that still left the ability to
change the where clause on the current statement or perform a subselect
which can circumvent applicaiton security logic and/or allow you to call
any stored function.

 Modified Files:
  jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
src/interfaces/jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java