Why does TRUNCATE require a special privilege? - Mailing list pgsql-general

From Marcelo Fernandes
Subject Why does TRUNCATE require a special privilege?
Date
Msg-id CAM2F1VNkovvL_56K_6OJiYU8toUdEG1Jk7ABRQ426Geh8LMB+g@mail.gmail.com
Whole thread Raw
Responses Re: Why does TRUNCATE require a special privilege?
List pgsql-general
Hi,

From the documentation:

> TRUNCATE quickly removes all rows from a set of tables. It has the same
> effect as an unqualified DELETE on each table, but since it does not actually
> scan the tables it is faster.
> (...)
> You must have the TRUNCATE privilege on a table to truncate it.

Granted that TRUNCATE and DELETE are different operations under the hood, but
why would the TRUNCATE operation require its own specific privilege rather than
say, use the same privilege as the DELETE operation?

Any explanations or lore about this would be deeply appreciated.

Thank you,
Marcelo.



pgsql-general by date:

Previous
From: David Mullineux
Date:
Subject: Re: Enquiry-PR671953 - PostgreSQL (Support Required)
Next
From: Dominique Devienne
Date:
Subject: Re: Why does TRUNCATE require a special privilege?