Re: Must be owner to truncate? - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Must be owner to truncate?
Date
Msg-id 20050707205803.GL24207@ns.snowman.net
Whole thread Raw
In response to Re: Must be owner to truncate?  ("Jim C. Nasby" <decibel@decibel.org>)
Responses Re: Must be owner to truncate?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
* Jim C. Nasby (decibel@decibel.org) wrote:
> On Thu, Jul 07, 2005 at 01:48:59PM -0400, Tom Lane wrote:
> > I don't really agree with the viewpoint that truncate is just a quick
> > DELETE, and so I do not agree that DELETE permissions should be enough
> > to let you do a TRUNCATE.
>
> What about adding a truncate permission? I would find it useful, as it
> seems would others.

That would be acceptable for me as well.  I'd prefer it just work off
delete, but as long as I can grant truncate to someone w/o giving them
ownership rights on the table I'd be happy.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: "Ayush Parashar"
Date:
Subject: Multi-byte and client side character encoding tests for copy command..
Next
From: Stephen Frost
Date:
Subject: Re: Must be owner to truncate?