On Mon, Mar 15, 2021 at 12:20 PM Fred Habash <fmhabash@xxxxxxxxx> wrote:
If there is a 'grant trigger' why is there not a 'grant drop trigger'?
Because creating a trigger from scratch doesn't let you affect other triggers that you may not own (at least not directly). If drop permissions were grantable the user could drop any trigger attached to said table. The missing feature here is that triggers should probably have their own ownership separate from a trigger and a trigger can only be attached to a table where the trigger owner has trigger permissions. But the trigger owner can always drop their owned triggers.
Any other options since Chad has one table to allow John to drop triggers on?
Option 3 is the one that is expected to be used here. Well, aside from the "John the person asks Chad the person to drop the trigger".
David J.
