>> Hi. I have a problem. I use a Firebird 1.5.6 Server for a lot of applications, 5 databases on the same server.
>>
>> I need to find the number of connection for a single database, and the names of the users. For this i used IBX IBDatabaseInfo->UserNames->Count and IBDatabaseInfo->UserNames->Strings[i], in Builder C++.
>>
>> The problem is if i have started a lot of application, the number of connections is the TOTAL connections to the SERVER, not only for my database. I have only one connection to my TIBDatabase, but IBDatabaseInfo->UserNames->Count report 3, with 2 connection to another application, different database!!!
>>
>> Give my a valid solution to find only UserNames connected to my database!!!
> Can't be done in v.1.5, sorry. Firebird users connect to the server, then the server connects them to a database. You could make a log table in each database that records logins and logouts.
>
> From v.2.1, you have the MON$ATTACHMENTS table that you can query. It works only with databases of ODS 11.1.
>
> Coming in Firebird 3 is the ability to have a dedicated security database for each database - even to embed a security database inside a user database.

Are you sure this is impossible, Helen? We used Fb 1.5 way after its
"best before" date (upgraded only a year or two ago), and I'm almost
certain I used IB_SQL to verify no-one was connected to the database of
interest before doing DDL (though you made me doubt, I'm no longer 100%
certain the databases were on the same server, we had at least two
Firebird servers).

This link http://www.firebirdfaq.org/faq10/ indicates that using the
services API with SuperServer it is possible to find active connections,
but it doesn't say anything about it being per database or not.

Set