How can I prevent/restrict regular users, that do have select rights granted on tables etc, to perform backup of Postgres database?

Is there a way to enable users to connect, select, update etc. tables in the database, but to disable them to backup database (e.g. via pgAdmin4)?

  • 4
    How, security wise, is SELECT * FROM table different than doing (some kind) of backups? If a user can do this SQL query, then he can back up the data... Aug 6 '19 at 22:31
  • 1
    pg_dump does nothing different. It simply runs select * from .. for every table. Aug 7 '19 at 5:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.