Re: [sqlite] Access Permission on Table

2013-07-23 Thread techi eth
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

Re: [sqlite] Access Permission on Table

2013-07-22 Thread Hick Gunter
http://www.sqlite.org/c3ref/set_authorizer.html -Ursprüngliche Nachricht- Von: techi eth [mailto:techi...@gmail.com] Gesendet: Montag, 22. Juli 2013 11:03 An: General Discussion of SQLite Database Betreff: [sqlite] Access Permission on Table Is their any statement I can build using

Re: [sqlite] Access Permission on Table

2013-07-22 Thread Simon Davies
On 22 July 2013 10:02, techi eth 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

[sqlite] Access Permission on Table

2013-07-22 Thread techi eth
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