note 97484 deleted from security.database.sql-injection by degeberg
| From: | degeberg@php.net | Date: | Thu, 22 Apr 2010 11:13:48 +0000 |
| Subject: | note 97484 deleted from security.database.sql-injection by degeberg | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-168502@lists.php.net to get a copy of this message | ||
Note Submitter: willbradley
----
fyrye: I disagree. Changing your tables to make them harder for attackers to guess is the very
definition of security through obscurity. (http://en.wikipedia.org/wiki/Security_through_obscurity)
It's more likely that someone will damage your database on accident from oddly-named tables
than that an attacker will give up after only a few guesses as to table names; after all,
what's to prevent them from injecting '; SHOW TABLES; -- into your query?
The point here is to lock down the interface you're opening from PHP to the database such that
injection isn't possible in the first place.