Re: AW: AW: Re[2]: [firebird-support] Link system tables to trigger

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

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

AW: AW: Re[2]: [firebird-support] Link system tables to trigger

['Check_Mail' check_m...@satron.de [firebird-support]]

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 

mon$attachments a 

where a.mon$attachment_id=CURRENT_CONNECTION

 

 

Regards,

Karol Bieniaszewski

Re: AW: Re[2]: [firebird-support] Link system tables to trigger

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Hi,you can do this by:Select * from mon$attachments a where 
a.mon$attachment_id=CURRENT_CONNECTIONRegards,Karol Bieniaszewski
null

AW: Re[2]: [firebird-support] Link system tables to trigger

['Check_Mail' check_m...@satron.de [firebird-support]]

Hello,

 

I thought similar, would call a stored procedure in my application and set the 
current user. 

 

But there was a little bit hope, that I can get it by using monitor tables, the 
attachment-table includes all informations and perhaps there is a reference to 
the statements 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 list of users within your database.

Then you can set a variable for connection named i.e. my_current_user, fill it 
from the application and then use it in i.e triggers in the same manner that 
you would use current_user.

 

HTH

Marcin

 

-- Wiadomość oryginalna --

Od: "Svein Erling Tysvær setys...@gmail.com   
[firebird-support]" mailto:firebird-support@yahoogroups.com> >

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 want to get the Windows user (or similar) and not the 
Firebird user (since all use the same Firebird user through ODBC). I have no 
clue whether that is possible to do in a trigger or not, but there's hopefully 
someone else on this list that knows the answer.

 

Sorry,

Set

 

Den tir. 12. mar. 2019 kl. 10:48 skrev 'Check_Mail' check_m...@satron..de 
  [firebird-support] 
mailto:firebird-support@yahoogroups.com> >:

 

Hello Set,

 

all users connecting over odbc with the same user, so I cannot separate the 
user, which changed the record. It is possible to get it over the 
transactions-table?

 

Von: firebird-support@yahoogroups.com  
 mailto: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 
(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] 
mailto:firebird-support@yahoogroups.com> >:

 

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 ip of the client. Can I link this with the 
changing?

 

Thank you.

 

Best regards

 

Olaf