Trond wrote:

> If you use Firebird version >= 2.1 you can use something like this:
>
> SELECT ma.MON$USER, ma.MON$REMOTE_ADDRESS,ma.MON$TIMESTAMP,
> ma.MON$REMOTE_PROCESS,
> ma.mon$attachment_id, ma.mon$attachment_name, ma.mon$role,
> ma.mon$state,
> ma.mon$stat_id, ma.mon$server_pid,ma.mon$remote_pid
> FROM MON$ATTACHMENTS MA
> WHERE ma.MON$ATTACHMENT_ID <> CURRENT_CONNECTION

Those are only connected users. He wants to get a list of all user
accounts on the server.

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================