How to prevent regular users to backup database, in Postgresql

Ask Question

Asked 5 years, 4 months ago

Modified 5 years, 4 months ago

Viewed 340 times

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

asked Aug 6, 2019 at 19:54

zlatko

1751 silver badge6 bronze badges

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...
– Patrick Mevzek
Commented Aug 6, 2019 at 22:31
1

pg_dump does nothing different. It simply runs select * from .. for every table.
– user1822
Commented Aug 7, 2019 at 5:31

Add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.