#41059 [Opn->Bgs]: Perhaps PDO could have a settable readonly attribute

ID: 41059 Updated by: tony2001@php.net Reported By: leifspb at gmail dot com -Status: Open +Status: Bogus Bug Type: Feature/Change Request Operating System: Linux PHP Version: 5.2.1 New Comment: To do that PDO would need a full-featured SQL parser to distinguish between read and write SQL statements. Previous Comments: ------------------------------------------------------------------------ [2007-04-11 22:35:01] leifspb at gmail dot com Description: ------------ Perhaps PDO could have a settable readonly attribute. That way scripts which only require readonly access would be that much more secure. Of course, this could be implemented as a second database user which only has readonly access but some people may be on shared hosts which only give one database user. There is no substitute for properly escaping all user input but this could provide one more layer of protection. Reproduce code: --------------- N/A Expected result: ---------------- N/A Actual result: -------------- N/A ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=41059&edit=1