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.


Regards,


Ann