Vacuuming by non owner/super users?

From: Paul McGarry <paul(at)paulmcgarry(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Vacuuming by non owner/super users?
Date: 2021-03-07 23:14:01
Message-ID: CAPrE0SYPGJAmYYz1w5hhUeYg_QmUYxoAxHEaPYRQ-y7YhpDsJQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible for a non-owner or non super user to be given permission to
vacuum tables in the DB?

My initial thought is no, but the documentation says:

"To vacuum a table, one must ordinarily be the table's owner or a
superuser."

Where the "ordinarily" seems to imply there might be some non-ordinary way
of performing a vacuum?
(If it really is just table owner or super user, then the sentence would be
clearer without the "ordinarily").

I am trying to split up DB maintenance, ie would like to give permission to
vacuum DB/tables without giving them full rights to do other stuff on the
tables.

Thanks for any advice.

Paul

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2021-03-07 23:38:02 Re: Log files polluted with permission denied error messages after every 10 seconds
Previous Message Adrian Klaver 2021-03-07 19:01:07 Re: Need help with clarification on stored procedure support in PostGreSQL database