Subject RE: [firebird-support] Alter Triggers
Author Alan McDonald
> Is it possible to allow users other than the owner of the database to
> alter triggers, in my case only the header (ALTER TRIGGER trigger_name
> INACTIVE / ACTIVE)?
>
> I would need such a feature for performance reasons.
>
> Environment:
>
> Firebird SS 1.5
>
>
>
> Regards,
> Christian

You can get the same effect (i.e. triggers not firing) by making this
process (i.e. the one you want to remain inert) a process of a special user.
You then test for the user and only fire the contents of the trigger when
the user is not this special user. Replication models use this technique.
Alan