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.