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.
