What permissions are needed to truncate a table in PostgreSQL?
1
vote
1
answer
4339
views
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?
Asked by Manngo
(3145 rep)
Jun 18, 2023, 12:25 AM
Last activity: Jun 18, 2023, 07:04 AM
Last activity: Jun 18, 2023, 07:04 AM