Subject MON$ATTACHMENTS anomaly - any ideas anyone?
Author tomsee7
The following sql is used to see who is currently connected:
SELECT MON$USER, MON$REMOTE_ADDRESS, MON$REMOTE_PID FROM MON$ATTACHMENTS

We use trusted authentication on Windows and an anomaly exists (Win Server 2003, FB 2.1.3.18185) in that (for example):

Out of 6 users,
3 are shown under MON$USER as sysdba(!) whereas
3 are shown under MON$USER as expected (e.g. DOMAIN\USERNAME).

Has anyone else seen this or can comment as to what may be the reason?

Thanks,
Tom