Subject Re[2]: [firebird-support] Link system tables to trigger
Author Marcin Bury
Post date 2019-03-12T10:26:15Z
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 setysvar@... [firebird-support]" <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_mail@... [firebird-support] <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 <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

 

 

 

Den tir. 12. mar. 2019 kl. 09:20 skrev 'Check_Mail' check_mail@... [firebird-support] <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