Subject Re: [firebird-support] Re: Set custom value on connection system info
Author livius
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
Karol Bieniaszewski
Sent: Saturday, February 3, 2018 9:14 PM
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 dimitr@... [firebird-support] <>:

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




Avast logo

Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie antywirusowe Avast.