Re: Read Only Database

When you created a table, it has access also for public. why don't you revoke that perms too. revoke all on "adiehl".tdummy1 from "public"; At 04:55 PM 15/07/98 -0500, you wrote: > Hi, > > Is there a way to create a read-only database for the creator? Maybe > this is trivial, but the following test script fails because the 3rd > insert succeeds. > > Thanks for the help in advance, > > Aaron Diehl > Sr. Database Administrator > Host Marriott Corporation > -- Aaron.Diehl@marriott.com > > create table tdummy1 > ( dummy_cd char(5) primary key, > dummy_descr varchar(255,1) not null > ) > ;> > insert into tdummy1 > values ("test1","This is only a test. This is the first record");> > insert into tdummy1 > values ("test2","This is only a test. This is the 2nd record");> > revoke all on "adiehl".tdummy1 from "adiehl"; > grant select on "adiehl".tdummy1 to "adiehl";> > insert into tdummy1 > values ("test3","This is only a test. This is the 3rd record");> > > > > Goldy Pastor Murillo Consultora Proyecto ILACO e-mail: gpastor@ilaco.gov.bo goldypm@yahoo.com goldypm@caoba.entelnet.bo www : www.ilaco.gov.bo Telf : 591-2-372703 La Paz - Bolivia