Re: Regarding TODO item "%Add a separate TRUNCATE

From: Gevik Babakhani <pgdev(at)xs4all(dot)nl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Regarding TODO item "%Add a separate TRUNCATE
Date: 2006-04-26 18:23:13
Message-ID: 1146075793.19962.21.camel@voyager.truesoftware.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 2006-04-26 at 13:54 -0400, Tom Lane wrote:
> The question that really ought to be answered before doing any of this
> is why DELETE privilege shouldn't be sufficient to allow TRUNCATE.

This is actually a very good one I think. Perhaps we shouldn't code and
overkill making things more complex. The only reason I can think of
having a separate TRUNCATE permission is when one could not ROLLBACK a
TRUNCATE. But this is not the case. We can rollback a TRUNCATE :) :)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2006-04-26 18:23:16 Re: Regarding TODO item "%Add a separate TRUNCATE permission"
Previous Message Alvaro Herrera 2006-04-26 18:19:03 Re: Regarding TODO item "%Add a separate TRUNCATE permission"