Subject Re: [firebird-support] Privileges changes visibility
Author Ann W. Harrison
Si Carter wrote:
>>Hard commit is made after the grant/revoke, still the other
>>connection (in the other application) doesn't detect the
>>change unless it is disconnected and reconnected.
> Other connections need to re-start their transactions too.

I'm afraid privileges for a user are set at first reference
to a table and continue for the duration of the connection.
They are not refreshed at transaction start. If we want to
recognize grant/revoke on the fly, then we need to notify
all interested connections, which is not hard but is not
currently done.