Re: [sqlite] block alter table command / table Constraints

2011-03-31 Thread Simon Slavin
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,

Re: [sqlite] block alter table command / table Constraints

2011-03-31 Thread Simon Slavin
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. > >

Re: [sqlite] block alter table command / table Constraints

2011-03-31 Thread Igor Tandetnik
On 3/31/2011 10:12 PM, 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. > >

[sqlite] block alter table command / table Constraints

2011-03-31 Thread RAKESH HEMRAJANI
Hi Team, Need ur expertise with below 2 problems 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