> Il 14/06/2012 12.36, Thomas Steinmaurer ha scritto:
>>> On 2012-06-13 18:56, Thomas Steinmaurer wrote:
>>>> The condition could be queried e.g. by a COUNT(*) on the MON$ATTACHMENTS
>>>> monitoring table or whatever you want to be included in the condition.
>>>
>>> Thomas,
>>> Just by the way: do you know a simple way (a stored procedure with
>>> elevated rights?) to get *all* active connections from MON$ATTACHMENTS
>>> while connected as an ordinary user (not with the RDB$ADMIN role)?
>>
>> Good one. No, AFAIK there is no way, thus my suggestion with querying
>> MON$ATTACHMENTS in an ON CONNECT trigger only works if connecting with
>> SYSDBA or the database owner and not with an ordinary user.
>>
>
> Does MON$ATTACHMENTS list users also for Classic, since Classic uses
> different processes?
>

Yes.

--
With regards,
Thomas Steinmaurer
http://www.upscene.com/