What settings do I have to set to make my
IB_Queries/Transaction/IB_Connection allow a user/role which does not have
insert/update/delete rights for tables.
i.e. I have a role which is trying to be an enquirer role only. No editing.
Permissions for the role are set to SELECT REFERENCE on all tables
When I run the app logged on as this role, I get all my queries complaining
about not having write access to the table in question.
I've tried all the settings of readonly on queries and transactions and
prevent editing etc on queries, and request live=false
I still can't escape permission exceptions..
what do I need to do?
Alan