| Subject | Re: [firebird-support] Re: Set custom value on connection system info |
|---|---|
| Author | livius |
| Post date | 2018-02-04T09:21:22Z |
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
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] <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.
|