Re: BUG #7716: Only owner can drop trigger?

On Fri, 2012-11-30 at 23:41 +0000, keith(at)omniti(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7716
> Logged by: Keith Fiske
> Email address: keith(at)omniti(dot)com
> PostgreSQL version: 9.2.1
> Operating system: Any
> Description:
>
> This is documented in the DROP TRIGGER section of the documentation, but it
> doesn't seem to make any sense. If a role has permission to create a
> trigger, why can that same role not have the same permissions to drop it,
> even if that role doesn't own the table?

My guess is that it's to prevent someone from dropping a trigger created
by someone else.

I agree that it's inconsistent. I'm not sure why they added the separate
"TRIGGER" privilege in the first place, but it was done more than 10
years ago.

Regards,
Jeff Davis