What permissions are needed to truncate a table in PostgreSQL?

Question

I’ve just started with a web host which supports PostgreSQL.

When setting up a database user, I have the choice of the following privileges:

■ ALTER ■ CREATE ■ DELETE
■ EXECUTE ■ DROP ■ EVENT
■ INDEX ■ INSERT SELECT
■ TRIGGER ■ UPDATE

That doesn’t include TRUNCATE, though it does include more drastic privileges. I plan to include the DELETE,EXECUTE,INSERT,SELECT,UPDATE privileges, but what’s needed to permit TRUNCATE without giving too much away?

Answer 1

You need to have the TRUNCATE privilege to truncate a table (or be a superuser).

Since PostgreSQL has no INDEX, EVENT, ALTER or DROP privileges, I suspect that you are using a different software.