I think you need to grant the DROP USER privilege to the trigger owner, even if the user has a powerful role like DBA.

I ran into something like this with a stored proc and execute immediate.

-John