Neil,

> I know that it is possible to see who is currently connected to a database but is it possible to see how they have connected?
>
> By which I mean is it possible to see whether they are connected from, say, IBConsole, IBQuery or an application?

MON$REMOTE_PROCESS in MON$ATTACHMENT, but AFAIK this needs at least V2.1
of the client libraries.


--
With regards,
Thomas Steinmaurer

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/