Subject Re: [firebird-support] Privileges changes visibility
Author Jaimy Azle
On Tuesday, November 1, 2005, 4:02:32 PM, Bambang P wrote:

>>> Will opened connection detect user privileges changes which
>>> happened after the connection opened?

>> I think it depends on transisolation level because privilegies are
>> read from system tables.

> Apparently not. In the my application, I've tried read committed, and
> unless the connection is closed and reopened, changes on user
> privileges won't be detected.

transisolation is correct, you just need to hard-commit your
transaction and reopen it to make those changes applied to your


-Jaimy Azle
|| Personal Weblogs: ||
|| Personal Delphi Weblogs: ||
* Pengantar Pemrograman Database C/S, Delphi dan Firebird

“You make a lot of money by moving from number two to number one.”
-- Larry Ellison, CEO Oracle Corp.