On 21 Feb 2011, at 9:35am, Philip Graham Willoughby wrote: > On 20 Feb 2011, at 16:18, thilo wrote: > >> My DB is owned by a different user (www) and I as root insert some data. > ... >> Are there any suggestions on how to make this workable? > > Don't do that. Unless you can guarantee that no malicious user has been able > to alter your database it isn't safe to interact with it as root if you're > using a version of the sqlite3 shell that has the .load built-in. Use su or > sudo to become www and interact with your data as the owning user.
Would it be feasible to copy whatever protection is on the database file to any temporary files like journal files ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
