Dmitry Sibiryakov wrote:

>On 31 Aug 2005 at 12:27, Ann W. Harrison wrote:
>
>
>
>>What other operations cause problems?
>>
>>
>
> With cached statements? Potentially - changing the role without
>reconnect. Cached prepared statement will be executed with previous
>rights.
>
>
>

That is the intended behavior. Rights are checked at prepare time, not
execute time. An application may intentionally want to retain a
prepared statement after changing the active role(s).

--

Jim Starkey
Netfrastructure, Inc.
978 526-1376