On 1 Apr 2011, at 3:25am, Simon Slavin wrote: > > On 1 Apr 2011, at 3:12am, RAKESH HEMRAJANI wrote: > >> 1) how to make a table read only, such that any user can only insert but >> can't update (table schema) or drop the table >> >> alter table / drop table arent allowed on sqlite_master, need similar >> restrictions on my custom table. >> >> by setting the tabFlags to TF_Readonly, i m able to prevent the user from >> dropping the table but >> alter table is still allowed (can add or drop columns) > > SQLite does not really have a user/privilege/protection model. However, you > can put the table in its own database file, and open the database file > read-only, using a flag value of 1: > > http://www.sqlite.org/c3ref/open.html > http://www.sqlite.org/c3ref/c_open_autoproxy.html
I'm sorry, I did not read that correctly. Please ignore what I wrote and pay attention to Igor. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users