Hi,
what problem with MON$ATTACHMENTS? There you have info who is logged and from
where.
you have:
- user
- IP + port
- application name
- Remote PID (process ID)
what more you need? You can bind user name with your “user” by some table.
If you really need more info, create table with ATTACHMENT_ID + USER_NAME + any
info required and populate it with db trigger like ON CONNECT
regards,
Karol Bieniaszewski
From: marco andreolli dra...@gmail.com [firebird-support]
Sent: Saturday, February 3, 2018 9:14 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Set custom value on connection system info
Thanks Dmitry for your answer,
but RDB$SET_CONTEXT() it's not right for me, because it store information in
actual connection (or transaction) and they can not be read out of this (with a
monitor program for example).
With my monitor application I would know not only the connection (with the
remote process) but also the person who created them (who is logged).
2018-02-02 20:20 GMT+01:00 Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] <firebird-support@yahoogroups.com>:
02.02.2018 11:46, marco andreolli wrote:
>
> I use Firebird 2.5, I would known if is it possible attach a custom
> value on a connection info.
https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-functions-scalarfuncs.html#fblangref25-functions-workcontext
> Actually I can see the number of connection on a database and other
> useful info with MON$ATTACHMENTS, but I would know If I could set a
> variable linked at the current connection.
MON$CONTEXT_VARIABLES
Dmitry
---
Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie
antywirusowe Avast.
https://www.avast.com/antivirus
