On 8/03/2009 4:27 AM, P Kishor wrote: > On Sat, Mar 7, 2009 at 10:59 AM, Tom Spencer <tspenc...@gmail.com> wrote: >> Is there a way to set the current database handle as read-only? I'm >> connecting to an SQLite3 database (actually two including an attached >> database) using Perl with DBD::SQLite, which doesn't seem to implement >> the ReadOnly database handle attribute. Is there some kind of setting >> or pragma that will set the handle as read only just for that >> connection? >> > > > This is puzzling... you are the one writing the programs... just don't > write to the database. How hard can that be? > > On the other hand, you can always just chmod the SQLite db file to 444.
I too am puzzled. Perhaps the app involves a web server accepting any bunch of text from anybody who knows the URL and just running the text as an SQL query -- i.e. read-only is perceived to be a last-ditch (only?) defence against an SQL injection attack. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
