Unfortunately this way is not practicable because every user comes to a
certain situation where triggers should be deactivated :-)

Christian

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