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 :) :) ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org