X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 56E0852A5C for ; Fri, 4 Mar 2005 16:33:12 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15320-04 for ; Fri, 4 Mar 2005 16:33:05 +0000 (GMT) Received: from resmta04.ono.com (smtp.ono.com [62.42.230.12]) by svr1.postgresql.org (Postfix) with ESMTP id 5641952A5A for ; Fri, 4 Mar 2005 16:33:04 +0000 (GMT) Received: from [80.58.11.235] by resmta04.ono.com with HTTP; Fri, 4 Mar 2005 17:33:02 +0100 Date: Fri, 4 Mar 2005 17:33:02 +0100 Message-ID: <4208B84C0001250D@resmta04.ono.com> From: juanmime@ono.com Subject: Re: How to deny remote backups ? To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-15" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.49 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, NO_REAL_NAME X-Spam-Level: * X-Archive-Number: 200503/44 X-Sequence-Number: 16542 >>>> >>>> The user DB that connects to the remote DB has insert and delete per= missions >>>> (he is the owner of the DB). >>>> >>>> The question is ... how can I block or forbide the remote DB duplica= tion >>>> ?. I think that a remote person that knows the user DB and his passw= ord, >>>> 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 c= an do >> this. OK. but I think that an aproximation to the solution or a half solution c= ould be deny the user consulting the system database catalog or (pg_tables). I= n that case, the user is not able to know the name of the tables inside th= e db, and therefore he does not know which are the tables to dump. I think also, that pg_dump could fail at this scenario. 1. What do you think about this ? 2. Is it possible (deny the access to the system catalog or tables (like pg_tables) to a certain user ? Thank you very much.