On Tuesday, November 1, 2005, 2:44:10 PM, Dimitry Sibiryakov 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.



--
Bambang P.


Age is a very high price to pay for maturity.