Does anyone know the fastest, simplest way for an application to acquire a
readonly role?
Create the Role OK, give the role readonly access (SELECT and REFERENCE) OK
But for all IBO components which autogenerate UPDATE sql, the sql is
prepared when you open the select query and thus raises an exception
immediately.
Previously I have done things like force all components to have custom SQL
and a role logon triggers a clearing of all SQL properties of all
components.
Perhaps there's a faster way to avoid all queries preparing?
regards
Alan McDonald