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.
Thanks & regards,
Alastair.
-----Original Message-----
From: John Minyo II
Sent: Thursday, October 21, 2010 8:10 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: New update permissions
At 02:12 PM 10/21/2010, you wrote:
Since downloading the latest version this morning I keep getting error
messages that “NONE� or “ADBB� (my login) do not have permission to
select data from whatever table I am trying to use.
The only way that I seem able to do anything is as the owner.
Anyone any ideas what has changed & what I need to do to correct it?
Hello Alastair,
Can you be more specific on how you are "using"
the table? SELECT, UPDATE, DELETE, etc.?
In order to print a report/label or run a form,
you must have SELECT permissions for that table.
If there are any slave tables or look-up
variables within the form, report, or label, you
must have SELECT permission for that table as well.
For the Data Designer, you must have ALTER permissions for the table.
With your thread, it has come to our attention
that an enhancement was not listed in the latest
"What's New in R:BASE eXtreme 9.0 Update 04" PDF document:
04. For database User Privileges, the Data
Designer will now correctly require SELECT
permissions for the SYS_INDEXES, SYS_TRIGGERS,
and SYS_PROCEDURES system tables, along with the
standard ALTER permission to be assigned for a
USER, for a defined table. This is because the
availability of index and trigger information
within the R:BASE eXtreme 9.0 Data Designer.
The document has been updated, and is available here:
http://www.rbase.com/rbg90/WhatsNewInRBASEeXtreme90_Update04.pdf
Best regards,
John Minyo II
R:BASE Technologies, Inc.
Customer Service
