Subject | RE: [firebird-support] Alter Triggers |
---|---|
Author | Alan McDonald |
Post date | 2004-06-07T09:46:59Z |
> Is it possible to allow users other than the owner of the database toYou can get the same effect (i.e. triggers not firing) by making this
> 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
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