I forgot to say that from performance POV you should do this only once in eg
connection trigger and set context vars.Use then this vars in
triggersRegards,Karol Bieniaszewski
null
Hello Karol,
perfekt, thank you!
Von: firebird-support@yahoogroups.com
Gesendet: Dienstag, 12. März 2019 14:43
An: firebird-support@yahoogroups.com
Betreff: Re: AW: Re[2]: [firebird-support] Link system tables to trigger
Hi,
you can do this by:
Select
*
from
Hi,you can do this by:Select * from mon$attachments a where
a.mon$attachment_id=CURRENT_CONNECTIONRegards,Karol Bieniaszewski
null
or transactions..
Von: firebird-support@yahoogroups.com
Gesendet: Dienstag, 12. März 2019 11:26
An: firebird-support@yahoogroups.com
Betreff: Re[2]: [firebird-support] Link system tables to trigger
Olaf
If you use same firebird user for all application users, I assume that you have
some
use current_user.
HTH
Marcin
-- Wiadomość oryginalna --
Od: "Svein Erling Tysvær setys...@gmail.com [firebird-support]"
Do: firebird-support@yahoogroups.com
Data: 12.03.2019 11:15:54
Temat: Re: [firebird-support] Link system tables to trigger
O, I see, Olaf, you w
actions-table?
>
>
>
> *Von:* firebird-support@yahoogroups.com
>
> *Gesendet:* Dienstag, 12. März 2019 09:52
> *An:* firebird-support@yahoogroups.com
> *Betreff:* Re: [firebird-support] Link system tables to trigger
>
>
>
>
>
> Isn't current_user (
> http
@yahoogroups.com
Betreff: Re: [firebird-support] Link system tables to trigger
Isn't current_user
(https://firebirdsql.org/refdocs/langrefupd21-current_user.html) sufficient?
Den tir. 12. mar. 2019 kl. 09:20 skrev 'Check_Mail' check_m...@satron.de
<mailto:check_m...@satron.de> [firebird-s
Isn't current_user (
https://firebirdsql.org/refdocs/langrefupd21-current_user.html) sufficient?
Den tir. 12. mar. 2019 kl. 09:20 skrev 'Check_Mail' check_m...@satron.de
[firebird-support] :
>
>
> Hello,
>
> I would like to log some changes in tables, in germany we must save this
> for dsgvo
Hello,
I would like to log some changes in tables, in germany we must save this for
dsgvo (customer data).
Now, I can do this with trigger, but can I link this changing with the
system tables, that I could get the user? The mon$attachment shows me all
active attachments with the user and the