Hi,

I have a problem that I hope somebody can help with.

We're using Firebird 2.0 and need to limit the number of users that
can connect to the database. The way we need to do it is:

Say, for example, our customer is allowed 10 simultaneous users to the
database at one time. Each application can generate several
connections, but these connections should only count as one connection
when calculating the number of connections against the licence.

e.g. The following connections should count as three connections
against the licence:

IP Address USER
10.1.1.1 JOHN |
10.1.1.1 JOHN |- Counts as one connection
10.1.1.1 JOHN _|
192.168.1.1 JOHN |
192.168.1.1 JOHN _|- Counts as one connection
10.1.1.1 FREDRICK |
10.1.1.1 FREDRICK |
10.1.1.1 FREDRICK |- Counts as one connection
10.1.1.1 FREDRICK |
10.1.1.1 FREDRICK _|

Does this make sense?

I'm sure this should be possible using RDB$GET_CONTEXT, but can't
figure out how to do it.

Cheers,
Paul