what problem with MON$ATTACHMENTS? There you have info who is logged and from 
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

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.


  > 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.



Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie 
antywirusowe Avast.
  • [firebird-s... marco andreolli dra...@gmail.com [firebird-support]
    • [fireb... Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
      • Re... marco andreolli dra...@gmail.com [firebird-support]
        • ... 'livius' liviusliv...@poczta.onet.pl [firebird-support]
        • ... Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
          • ... marco andreolli dra...@gmail.com [firebird-support]
            • ... 'livius' liviusliv...@poczta.onet.pl [firebird-support]
              • ... marco andreolli dra...@gmail.com [firebird-support]
                • ... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
                • ... marco andreolli dra...@gmail.com [firebird-support]

Reply via email to