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?

Fulvio