Re: Truncate Triggers - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Truncate Triggers
Date
Msg-id 3602.1201287650@sss.pgh.pa.us
Whole thread Raw
In response to Re: Truncate Triggers  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Truncate Triggers  (Stephen Frost <sfrost@snowman.net>)
Re: Truncate Triggers  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> On Fri, 2008-01-25 at 10:44 -0500, Tom Lane wrote:
>> There are way too many table privilege bits already; to add more you
>> need something a lot stronger than a "might be nice" argument.

> People use TRUNCATE whatever we say. If you force people to be table
> owners or superusers you merely restrict their security options.

By that argument you could justify a separate privilege bit for anything
at all, eg, each sub-variant of ALTER TABLE.  Please present an actual
argument why TRUNCATE should get its own bit.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposal: Integrity check
Next
From: Stephen Frost
Date:
Subject: Re: Truncate Triggers