Em 13/6/2012 14:56, Thomas Steinmaurer escreveu:

>
> Not bullet-proof, but you could write an ON CONNECT database trigger and
> throw an exception if you want to abort the connection establishment.
> 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.
>
> Not bullet-proof in a way, that database trigger can be temporarily
> disabled at session level or deactivated/dropped when connecting with
> the database owner via a tool like isql etc. where you can issue a DROP
> TRIGGER statement.
>
>
> Regards,
> Thomas
>
>

Besides the cases you pointed out, there is the case of client lost
conection.

But I think that this is the easiest way to do it...

The OP could tell us some more info like:
Do you want to count the simultaneous connections or the number of users
? (ex. the costumer could have 10 valid users but are allowed to use
just 5 at a time)

see you !