Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 327229F9F49 for ; Tue, 12 Dec 2006 14:38:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 86179-02 for ; Tue, 12 Dec 2006 14:38:38 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id E73729F9398 for ; Tue, 12 Dec 2006 14:38:39 -0400 (AST) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Tue, 12 Dec 2006 18:38:32 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 12 Dec 2006 12:38:33 -0600 Subject: Re: Hide structure From: Scott Marlowe To: "dev.department" Cc: pgsql-admin@postgresql.org In-Reply-To: <00e201c71886$e7ef1c40$76671997@WEB> References: <00e201c71886$e7ef1c40$76671997@WEB> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1165948712.3243.126.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 12 Dec 2006 12:38:33 -0600 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/172 X-Sequence-Number: 23964 On Tue, 2006-12-05 at 10:01, dev.department wrote: > > > > Dear Sirs, > > We're a softwarehouse who is considering the possibility to insert the > PostgreSQL 8.1 database in our software. > How can we prevent the visualization of structure and data (tables, > views, etc.) of a PostgreSQL 8.1 database? Keep present that the > person who has installed PostgreSQL 8.1 is the administrator of the > PC in which it it installed, and so he could modify the configuration > files of PostgreSQL 8.1 server (for example files as "pg_hba.conf", > "postgresql.conf", ecc.). > > We've also seen that command "pg_dump" allows to visualize all > structures and data of a database simply knowing the user name and > not his password... You can't. Even if postgresql tried to make it possible, it would be wasted effort. anyone with any hacking knowledge could override it. If you don't want people doing that, then host the database yourself, on your own servers, and don't let the users directly log in.