Thanks for that Anderson & Thomas.

In that case, does it mean that the only way to tell the connecting (admin) users apart is by IP address?

Tom

--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:
>
> > 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?
>
> Windows trusted authentication is only used if configured in
> firebird.conf properly (mixed or trusted) AND if the user name is
> omitted when connecting to the database. If you provide a user name,
> then the native Firebird authentication is used.
>
> SYSDBA is shown, if either SYSDBA or a Windows user with administrative
> priviliges is connecting.
>
>
>
> --
> With regards,
>
> Thomas Steinmaurer
> Upscene Productions
> http://www.upscene.com
> http://blog.upscene.com/thomas/
>
> Download LogManager Series, FB TraceManager today!
> Continuous Database Monitoring Solutions supporting
> Firebird, InterBase, Advantage Database, MS SQL Server
> and NexusDB!
>