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]"
<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]
<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
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]
<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