Re: Allowing John to Drop Triggers On Chad's Tables

On Mon, Mar 15, 2021 at 12:20 PM Fred Habash <fmhabash(at)gmail(dot)com> 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.