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
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 |