Subject Re: Server and application names
Author blescouet
Hi,

--- In firebird-support@yahoogroups.com, "Roberto Freitas"
<solanofreitas@...> wrote:
>
> Hello,
> I use some applications that update records on a table in a distributed
> database (FireBird 1.5). This table has a Before Update trigger, and
> can be updated by different applications on different servers. When
> this trigger is fired, I must know (inside the trigger) what are
> current server and application names.
> How can I do it?
>

Creating reserved firebird users for each server and / or application
and testing the active user with the CURRENT_VARIABLE in the trigger
could be a solution...

B.L.