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: firstname.lastname@example.org 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] <email@example.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