Subject table access rights
Author Rick Roen
D7 IBO4.5B FB1.5

I'm getting ready to deploy some new software and have a question
about table access rights in TIB_Query components (and related
components like TIB_Cursor).

Say I have a "CUSTOMER" table with the following setup:

SQL: Select * from CUSTOMER order by NAME
EditSQL: Update CUSTOMER ...
InsertSQL: Insert into CUSTOMER ...
DeleteSQL: Delete from CUSTOMER...

If I log into the DB as a user who is allowed Edit, Insert and
Delete rights there is no problem. If the user does not have rights
I get a GDS error 335544352 "no permission to update/write". I think
IBO is preparing the EditSQL and others which triggers this error.

I tried to set the TIB_Query with PreventEditing = True etc. and
even setting ReadOnly = True, but neither stopped IBO from preparing
the statements.

If I delete the EditSQL etc. statement before opening the table
there is no problem since there is nothing to prepare.

Is this what I have to do, or is there a better way to manage user
access?

TIA

Rick