How to recreate trigger in DB2
Posted on 2009-02-11
I need to recreate a trigger in db2, if some modifications to its target table structure are done. So far I have done it by dropping and creating the trigger, and it works fine.
However, now I'm facing a situation, where another user, userB, with rights to the target table needs to be able to change the trigger too. userB does not have drop access to the trigger, so can't use the drop/create scheme.
Is there a way for userB to just update the trigger definition and does this require some special grants?