Subject | modify trigger for non-owners? |
---|---|
Author | Tobias Giesen |
Post date | 2001-09-19T22:01:56Z |
Hi!
I want to disable certain triggers to speed up some operations - after which
the triggers need to be re-enabled.
I'm using MODIFY TRIGGER for that, but non-owners of the database aren't
allowed to do that. Is there away to grant them that privilege, or another
way to disable the trigger? Such as a global flag that the trigger could
examine in order to know whether it should do anything or quit immediately?
Thanks.
Tobias
----------------------------------------
Tobias Giesen, Composer - ICQ # 97626829
http://www.tobiasgiesen.de
Check out TGTools, my Plug-In Collection
for Finale: http://www.tgtools.de
----------------------------------------
I want to disable certain triggers to speed up some operations - after which
the triggers need to be re-enabled.
I'm using MODIFY TRIGGER for that, but non-owners of the database aren't
allowed to do that. Is there away to grant them that privilege, or another
way to disable the trigger? Such as a global flag that the trigger could
examine in order to know whether it should do anything or quit immediately?
Thanks.
Tobias
----------------------------------------
Tobias Giesen, Composer - ICQ # 97626829
http://www.tobiasgiesen.de
Check out TGTools, my Plug-In Collection
for Finale: http://www.tgtools.de
----------------------------------------