Sample Header Ad - 728x90

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