On Tuesday, November 1, 2005, 6:55:29 PM, Jaimy Azle wrote:

> 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
> application.

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.


--
Bambang P.


If you're too open minded, your brains will fall out.