Thanks, John, RDCC e-mailed.
Regards,
Alastair.
-----Original Message-----
From: John Minyo II
Sent: Friday, October 22, 2010 2:09 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: New update permissions
At 05:51 AM 10/22/2010, you wrote:
Hello John - one example:
My main app on starting R:Base uses a form with a temporary second table.
As I write I have on my screen the Table Privileges for user PUBLIC and for
both the driving and temp tables I can see that SELECT, INSERT & UPDATE are
checked.
The only SYS tables with PUBLIC permissions are _DEFAUTS which has SELECT
and _LAYOUTS which has SELECT, INSERT & UPDATE checked.
At this stage no password or user name has been entered.
The form is called with the EDIT USING command although no editing is
actually done. (Using BROWSE greys-out a control that I do not want
greyed-out.)
The error message that I get is: User NONE does not have rights to select
data from table ThingsToDo
ThingsToDo is the TEMP table.
The only way to escape from the error is the kill R:Base with the Task
Manager in the Process tab since in the Apps tab nothing happens.
I have TRACEd through my app and everything is fine until the EDIT USING
command. Therefore the temp table is created properly.
If I add a line to the start of my app to "SET USER ADBB" I still get the
error however if I use the Owner password the form will run correctly.
I have been using this form many times daily for some years but, more
importantly, there was no change to it or the database between the last use
on Wednesday evening and the first use with update 4 yesterday morning.
From what you say I may need to check permissions when using the Data
Designer but that does not seem to apply to my current experience.
Alastair,
Your example appears to be specific to temporary tables, which should
be not be a problem.
Please send detailed instructions to the RBG9 RDCC. You may use the
built in RBG9 RDCC Client within R:BASE to provide us with feedback,
or send an email directly to [email protected].
Best regards,
John Minyo II
R:BASE Technologies, Inc.
Customer Service
