Kenny, the command that I use is this: GRANT SELECT, INSERT, UPDATE ON `SYS_Layouts3` TO PUBLIC, &vUserList
where vUserList is, surprise surprise, a list of the users!! (Me and my alter ego in case anybody wonders why a single user needs a userlist.) Presumably, I did it that way because I needed to but I don't remember now why. Regards, Alastair. From: Kenny Camp Sent: Monday, May 10, 2010 7:30 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Error SYS_Layouts3 does not exist - But it does. I granted all privileges to PUBLIC. And while working as the DB owner and layout on and with multi off (single user) I still get the error. I do not in the DB prior to adding the DB owner name. I was able to stop the error messages for users in the compiled version by editing the rbengine76.cfg and saving with layout off. But is the DB OK? Kenny From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr Sent: Monday, May 10, 2010 1:18 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Error SYS_Layouts3 does not exist - But it does. Kenny, give your users permission to access, and update if you want them to save the layouts, the sys_layouts3 table. Regards, Alastair. From: Kenny Camp Sent: Monday, May 10, 2010 6:55 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Error SYS_Layouts3 does not exist - But it does. Could someone tell me what is happening in my live database? I made many changes to my main database this weekend mostly adding a owner name and granting all privileges to public, and granting create to public to allow temp tables. This morning everything was OK for several hours until some compiled version 7.6 users started getting this error message. Error SYS_Layouts3 does not exist. I opened the database with the full version 7.6 and R> list sys_layouts3 it is there with 4 rows. R> browse all from sys_tables3 showed the error and after clicking past the error, it showed the data. I reloaded the database, but the error returned after a while. This system table saves custom layouts that we do not use. Autocheck full shows no errors, and the database appears to be OK. Comparing compute rows and compute count (1) from table gives the same number, so I don't believe it is a broken index. I want to unload and rebuild, but need to wait till after hours if possible. I found layout was set on and so set layout to off and the error does not show up any more in the full version but still appears when calling the browser in the compiled version. Any clues? Kenny ---------------------------------------------------------------------------- No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2865 - Release Date: 05/10/10 07:26:00 ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2865 - Release Date: 05/10/10 07:26:00
