| 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: | Whole Thread | Raw Message | 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 |