Hi Martin, Thank you, I'll definitely look into that. It's unfortunate that there isn't a simpler way to do this... oh well.
Best, Ross On Tue, Oct 14, 2014 at 7:22 AM, Martin Engelschalk < engelsch...@codeswift.com> wrote: > Hello Ross, > > you could add triggers to all tables that RAISE(ROLLBACK, 'Forbidden') on > all operations (insert, update and delete), see > http://www.sqlite.org/lang_createtrigger.html, bottom of the page. > However, it is difficult to see how to stop the downloaders from removing > these triggers or indeed any other mechanism to prevent changes to the > data. It is their file after download.... > > HTH > Martin > > Am 14.10.2014 08:19, schrieb Ross Altman: > >> I need to host a fixed, unchanging database online, and I want to make >> sure >> that anyone who downloads it cannot add to it. Is there any way to set the >> permissions to be read-only within sqlite? >> >> Thanks, >> Ross >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > -- > > *Codeswift GmbH * > Kräutlerweg 20a > A-5020 Salzburg > Tel: +49 (0) 8662 / 494330 > Mob: +49 (0) 171 / 4487687 > Fax: +49 (0) 3212 / 1001404 > engelsch...@codeswift.com > www.codeswift.com / www.swiftcash.at > > Codeswift Professional IT Services GmbH > Firmenbuch-Nr. FN 202820s > UID-Nr. ATU 50576309 > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
