How to grant VACUUM permission in VMWare Tanzu for Postgres

Products

• VMware Tanzu Platform Data
• VMware Tanzu for Postgres

Issue/Introduction

Which grant is needed to give to perform vacuum on tables owned by PUBLIC

Resolution

A table's owner user / role (accessible through pg_catalog.pg_tables view - tableowner column) or superuser can run vacuum on the table.

As of PostgreSQL 16, Granting explicit permissions to vacuum tables is not an available feature in the same release or prior releases.

GRANT MAINTAIN is available in PostgreSQL 17 allowing explicit granting of a set of permissions including vacuum to a non-super/owner user.