Postgres Pro
Downloads
Home   >   mailing lists

Re: Prevent users from executing pg_dump against tables - Mailing list pgsql-general

From David G. Johnston
Subject Re: Prevent users from executing pg_dump against tables
Date
Msg-id CAKFQuwa2gb6QKvUVuGTy4T1cScKgJEhaxvqwKDeJAZgpxpTWYg@mail.gmail.com
Whole thread Raw
In response to Prevent users from executing pg_dump against tables  (RAJAMOHAN <garajamohan@gmail.com>)
List pgsql-general
Tree view
On Wednesday, May 1, 2024, RAJAMOHAN <garajamohan@gmail.com> wrote:

 Main reason being I don't want the data to be copied from the database to their local machines.

You cannot stop it being copied to their local machine, you can only make it difficult.  And really not that difficult.

Trust but verify - i.e., use something like pg_audit.
 
David J.

pgsql-general by date:

Previous
From: Kashif Zeeshan
Date:
Subject: Re: Listing only the user defined types (with owners)
Next
From: Thom Brown
Date:
Subject: Re: Listing only the user defined types (with owners)