Re: BUG #7716: Only owner can drop trigger? - Mailing list pgsql-bugs

From Jeff Davis
Subject Re: BUG #7716: Only owner can drop trigger?
Date
Msg-id 1354326662.1766.127.camel@sussancws0025
Whole thread Raw
In response to Re: BUG #7716: Only owner can drop trigger?  (Keith Fiske <keith@omniti.com>)
List pgsql-bugs
On Fri, 2012-11-30 at 20:08 -0500, Keith Fiske wrote:
> So then don't give that other role trigger permissions if you don't
> want them to be able to drop a trigger. I'm actually thankful for the
> trigger permission since it allows the extension I'm working on to
> create triggers on tables the role doesn't own. But now it only
> half-works because it can't clean up after itself when the trigger
> needs to be dropped.

Allowing any user with TRIGGER privileges to drop a trigger seem like a
reasonable change to me. The only alternative I can think of (aside from
dropping the separate TRIGGER privilege) is to track the owner of the
trigger separately from the owner of the table, but that would be
strange, too.

Regards,
    Jeff Davis

pgsql-bugs by date:

Previous
From: Keith Fiske
Date:
Subject: Re: BUG #7716: Only owner can drop trigger?
Next
From: Cédric Villemain
Date:
Subject: extension installation faillure using VPATH and MODULEDIR