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.

--
Salam,

-Jaimy Azle
===========================================================
|| Personal Weblogs: http://jaim.log.web.id ||
|| Personal Delphi Weblogs: http://delphi.log.web.id ||
* Pengantar Pemrograman Database C/S, Delphi dan Firebird
http://delphi.log.web.id/blogs/delphi/000152.html
===========================================================

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