[RBG7-L] - Re: Temp tables and access rights

[John Engwer]

Thanks for the suggestion Alastair.  Create was checked but I executed another “grant create to public” to verify.  Still have the same problem.   John Engwer 412 751-2433   From: rbg7-l@rbase.com [mailto:rbg7-l@rbase.com] On Behalf Of Alastair Burr Sent: Tuesday, November 08, 2005 3:30 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Temp tables and access rights   John,   Have you added "GRANT CREATE TO PUBLIC" to your permissions. I don't know if it's still needed but long ago I found that TEMP tables needed it to work.   Regards, Alastair.     ----- Original Message ----- From: John Engwer To: RBG7-L Mailing List Sent: Tuesday, November 08, 2005 7:18 AM Subject: [RBG7-L] - Temp tables and access rights   I have an application that uses Grants to restrict access.  Yesterday I added a sub application that uses temp tables for part of an edit process.  The application works fine when I am logged on as owner but becomes erratic when users log on.  Everything works fine except when I try to use edit forms that modify data in one of the temp tables (edit using, single table, scrolling region).  Sometimes all of the rows do not show up; sometimes they do; sometimes I get black vertical bars in some of the fields.  If I exit out of the application I can browse the temp table and see and/or edit all of the data.  I am pretty sure it has something to do with the access rights but I don’t think access rights should apply to a temp table since it only applies to the user that created it.   Does anyone have any idea what may be wrong?   John Engwer 412 751-2433     No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/162 - Release Date: 05/11/2005