Subject | Re: Find out how a user has connected to the database |
---|---|
Author | grip_2ls |
Post date | 2011-10-19T09:44:17Z |
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
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/
>