> I assume you have requestlive set to true.role.
> This is how I do it. When the logon occurs (valid), I test for
> depending on role I run thru all the queries which should not haveediting
> rights and clear all the SQL (where I have written my own) and setrequest
> live to false where I depend on IBO to do it. (as you realise)statements even
> The trouble you are getting is IBO tries to prepare all the
> before trying anything other than the select.Thanks Alan,
I guess I have done something like your suggestion.
I wrote an SP to query the RDB$PRIVILEGE in the RDB$USER_PRIVILEGES
system table after the user logs in. If there is no "I"nsert
privilege, then I clear the InsertSQL property, and so on for delete
I tried setting RequestLive to true when the user does not have
privileges, but once the update/insert/delete SQL's are cleared,
this does not seem to matter. Am I missing something?