On Wed, Mar 22, 2017 at 1:33 PM, Clemens Ladisch <clem...@ladisch.de> wrote:
> Dominique Devienne wrote: > > On Wed, Mar 22, 2017 at 12:52 PM, R Smith <rsm...@rsweb.co.za> wrote: > >> There is no way to easily implement an automatic view-of-table > >> dropper. (I've tried to do something like this for an sqlite tool long > ago). > > > > Yes but... You can run a simple query on the view, like "select rowid > from v" and EXPLAIN that, > > and look for specific OpCodes [1] (like OpenRead), look at its P2 arg, > and lookup that root page in > > sqlite_master. > > sqlite3_set_authorizer() would be easier, and an official API. > yet the same issue I raised almost 2 years ago in [1] is still there though, i.e. you cannot "stack" authorizers (which imply you cannot compose/combine) them. We are still missing a sqlite3_get_authorizer API IMHO. --DD [1] http://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/msg89912.html _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
