> -----Original Message-----
> 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.

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://www.tectsoft.net/ - Homepage