Re: How to deny remote backups ? - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: How to deny remote backups ?
Date
Msg-id 20050304145600.GB17492@wolff.to
Whole thread Raw
In response to How to deny remote backups ?  (juanmime@ono.com)
List pgsql-admin
On Thu, Mar 03, 2005 at 09:45:47 +0100,
  juanmime@ono.com wrote:
>
> The user DB that connects to the remote DB has insert and delete permissions
> (he is the owner of the DB).
>
> The question is ... how can I block or forbide the remote DB duplication
> ?. I think that a remote person that knows the user DB and his password,
> can connect to the DB and make a pg_dump of the DB.

Only by not letting the user SELECT the data. If they can see it, they can
copy it. If the users really only need INSERT and DELETE access, you can do
this.

pgsql-admin by date:

Previous
From: Andrew Hammond
Date:
Subject: Re: How about putting distinct DB-schemas in extra DMBS instances
Next
From: David Wagoner
Date:
Subject: User Login Authentication from Multiple IP Addresses (DHCP)? pg_ hba.conf