> 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.


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


I've

> got a different problem, in which such solution would help a lot
> (meanwhile, my users connect with RDB$ADMIN, but that causes other
> problems, e.g. they can still connect to a database in single mode).