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 <mailto:check_m...@satron.de> [firebird-support] <firebird-support@yahoogroups.com <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
