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
