I am getting request from different process for different SQlite3 operation to be performed. Here I want to restrict Update/Alter/Drop operation to creator of the table but read can be done by all.
I am using sqlite3_exec() for query execution. In those scenarios can I directly map set_authorization function. Appreciate if I will get link to example. Cheers- Techi On Mon, Jul 22, 2013 at 2:53 PM, Simon Davies <simon.james.dav...@gmail.com>wrote: > On 22 July 2013 10:02, techi eth <techi...@gmail.com> wrote: > > Is their any statement I can build using SQLite3, which will provide me > > access permission over table. > > > > Let us say I have 3 tables (table 1, table 2, table 3). Here I am looking > > Read permission for one->many but Write can be done by creator of table > > only. If other will try to access then they couldn't be able to do & > error > > will be thrown. > > Perhaps http://www.sqlite.org/c3ref/set_authorizer.html helps... > > > > > Cheers- > > > > Techi > > Regards, > Simon > _______________________________________________ > 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
