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 6BC8E54D78 for ; Fri, 4 Mar 2005 17:30:04 +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 30054-08 for ; Fri, 4 Mar 2005 17:29:55 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 72426545EE for ; Fri, 4 Mar 2005 17:29:53 +0000 (GMT) Received: (qmail 25664 invoked by uid 500); 4 Mar 2005 17:45:35 -0000 Date: Fri, 4 Mar 2005 11:45:35 -0600 From: Bruno Wolff III To: juanmime@ono.com Cc: pgsql-admin@postgresql.org Subject: Re: How to deny remote backups ? Message-ID: <20050304174535.GA25380@wolff.to> Mail-Followup-To: juanmime@ono.com, pgsql-admin@postgresql.org References: <4208B84C0001250D@resmta04.ono.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4208B84C0001250D@resmta04.ono.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/46 X-Sequence-Number: 16544 On Fri, Mar 04, 2005 at 17:33:02 +0100, juanmime@ono.com wrote: > > OK. but I think that an aproximation to the solution or a half solution could > be deny the user consulting the system database catalog or (pg_tables). In > that case, the user is not able to know the name of the tables inside the > 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 ? I don't think it is a good idea. Since you are worried about this, I am going to guess that the users are running a client (such as psql) to do their inserts and deletes. If so, they are going to be able to find out the table names. If this isn't the case and everything is being done by an application running on the server, then you should be having that application control access. > 2. Is it possible (deny the access to the system catalog or tables (like > pg_tables) to a certain user ? You will break things if you prevent people from reading the system catalogs.