On Sat, Dec 7, 2013 at 8:45 PM, Joshua Grauman <jnf...@grauman.com> wrote:

> Ok, so now I have a new question.
>
> Is there a way to prevent changes to the schema, while still allowing
> inserts of new data to existing tables? I'd love to just prevent any
> changes to sqlite_master for a given database connection. I tried adding
> triggers to it similar to the ones I used below, but I get an error "Error:
> cannot create trigger on system table".


You may find this of interest:
http://www.sqlite.org/c3ref/set_authorizer.html
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to