If you're trying to do what I think you are, then you are better off
creating a user which noone knows about. Then you make the triggers fire
only when the USER <> SPECIALUSER. The special process you want will not to
fire the triggers when you fire the process off as SPECIALUSER
This method is used in the repliction process where the SPECIALUSER is ised
so as not to put more inserts/updates/deletes into the replication cycle

Alan

> -----Original Message-----
> From: Corneliu T. [mailto:corneliu_t@...]
> Sent: Monday, 23 June 2003 3:16 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Can I Activate/Inactivate a trigger from a
> non -SYSDBA account ?
>
>
>
> Hi,
>
> I'm traing to inactivate a trigger from a normal user
> account(non-SYSDBA).
> with:
>
> ALTER trigger AI_MYTABLE_IDMYTABLE inactive;
>
> And I receive an error message...
>
> MODIFY TRIGGER failed.
> no permission for control access to TABLE MYTABLE.
>
> My user has all rights(INSERT,UPDATE,DELETE,REFERENCE)
> on table MYTABLE and work fine in all situations but
> in this particular case not.
>
> Can someone help me?
>
>
> Corneliu T.
>
> =====
>
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>