Based on my research, There are the options I have identified to allow user 'John' to drop a trigger on a table owner by 'Chad' ..
1. Make John a superuser
2. grant chad to john ;
3. Have Chad create a wrapper definer-rights procedure to drop triggers & grant execute to John.
4. Give John Chad's password!
None of these options appeal to me. If there is a 'grant trigger' why is there not a 'grant drop trigger'?
Any other options since Chad has one table to allow John to drop triggers on?
----------------------------------------
Thank you
