Marc, you can only grant SELECT to most of the sys tables. Most of them are actually views. You can grant all privileges to the sys_form.. and sys_report.. and sys_label.. tables except modify.
--- Marc <[EMAIL PROTECTED]> wrote: > Thanks Albert > > I tried that no errors. > > Then I > Con to db entered owner password > went to table privileges ... public... sys_layout3 > everything was N across the screen, even for all > sys tables. > I clicked Edit, checked all of the boxes for select, > update... and all of the columns below, clicked OK > Then I got 3 errors > Error column sys_layout_name not in RBdefine > Error column sys_data not in RBdefine > I got this for each column in each sys table when I > tried it on the other sys_tables. > > I thought build 78 was suppose to grant access to public > on system tables? > > Maybe I need to delete the sys tables then do the upgrade again > since this db was converted / upgraded before build 78? > > Is this normal or does this mean something is wrong? > > Marc > > > > > > > ----- Original Message ----- > From: "Albert Berry" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Tuesday, December 28, 2004 3:11 PM > Subject: [RBG7-L] - Re: Sys_layout3 problems again > > > > A favoured technique when unusual problems arise is to do an unload/input > for the database. > > > > CONNECT <database> > > SET NULL -0- > > OUTPUT <database.str> > > UNLOAD STRUCTURE > > OUTPUT SCREEN > > OUTPUT <database.dat> > > UNLOAD DATA > > OUTPUT SCREEN > > > > Now edit the database.str file. Search for ALTER. > > Add two lines here: > > RETURN > > LABEL Indices > > > > and save the file. > > > > SET MESSAGES ON > > SET ERROR MESSAGES ON > > OUTPUT RELOAD.LOG > > RUN database.str > > This will create the structure without indexes and constraints > > RUN database.dat > > This will load all the data back into the database > > OUTPUT SCREEN > > Again edit the database.str file > > As the first line > > > > GOTO Indices > > > > Save the file > > > > OUTPUT RELOAD.LOG APPEND > > RUN Database.str > > OUTPUT SCREEN > > > > > > This will add back the indices and constraints. > > RBEDIT RELOAD.LOG > > Search for the word "ERROR" to see what has gone wrong. > > > > > > > > > > > > > > > > --- Marc <[EMAIL PROTECTED]> wrote: > > > > > Hi all > > > > > > I thought this problem was solved a few months ago but > > > it is back. I haven't used this db since then so I am not sure > > > when it came back. > > > > > > If I con to the db then enter the owner password > > > then do Edit all from table I get an error about > > > a missing sys_layout3 table. But it is there at the > > > R> when you do list sys%. > > > > > > If I put in the owner password first then con to the > > > db, then edit all from table NO error. > > > > > > I have looked for dup MSG and DLL files. > > > Deleted the CFG file, upgraded the DB, > > > reloaded..... > > > > > > This may not be a big deal since I can work around it > > > but it makes me nervous that there may be something > > > else wrong with my db and it will come back and > > > cause problems one day. > > > > > > Any suggestions? > > > Marc > > > > > > > > > > > > ===== > > Albert Berry > > Management Consultant > > RR2 - 1252 Ponderosa Drive > > Sparwood BC, V0B 2G2 > > Canada > > (250) 425-5806 > > (250) 425-7259 > > (708) 575-3952 (fax) > > [EMAIL PROTECTED] > > > > > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
