Subject Re: Find out how a user has connected to the database
Author grip_2ls
Hi Thomas

Thanks for the quick response.

I have a few further questions...

When I try and select from this table I get a message to say that it doesn't exist. I am logged in as sysdba - do I need to do anything else?

My db is 2.1.3.18185 and the GDS32.dll is version 6.3.3.18185

I assume that the remote process property has to be set as part of the connection string?

And finally, I assume that this is available via an api?

Thanks

Neil
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:
>
> 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/
>