| From: | Marcos Aurelio Nobre <marconobre(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | How do I create a Backup Operator account ? |
| Date: | 2019-07-30 00:49:56 |
| Message-ID: | CALrcA6=BD-+7tq=rDELRGtfWaStk2YznFMQb_tAdvZVcs6NBWQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all.
I need to create a PostgreSQL account , that only do a Backup and Restore
operations over a PGSQL Database .
My main difficulty is to only assign Backup and Restore capability to one
user account, unlike the ability to perform DQL and DML operations for
ordinary user accounts.
In POSTGRESQL there is no backup / restore privilege because these
operations are performed by server specific utilities.
One possibility that I thought would be:
I was wondering if it was possible to configure the pgAdmin4 menus to be
available for a particular login, only Backup & Restore items. But I'm not
sure how to associate a bank login account with a specific menu setting of
a client tool.
Could someone give me any ideas or directions?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil | 2019-07-30 02:37:22 | Re: How do I create a Backup Operator account ? |
| Previous Message | Adrian Klaver | 2019-07-29 23:04:21 | Re: Reproducing query plans in empty database: can I just copy stats and settings? |