From dev.manager@spazio3d.net Tue Dec 5 16:09:49 2006 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 6B7309FB28B for ; Tue, 5 Dec 2006 12:09:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 28260-06 for ; Tue, 5 Dec 2006 12:09:29 -0400 (AST) X-Greylist: delayed 00:06:37.473429 by SQLgrey-1.7.4 Received: from smtp5.aruba.it (smtpd3.aruba.it [62.149.128.208]) by postgresql.org (Postfix) with SMTP id 9F0149F9F7B for ; Tue, 5 Dec 2006 12:09:28 -0400 (AST) Received: (qmail 28317 invoked by uid 89); 5 Dec 2006 16:02:44 -0000 Received: by simscan 1.1.0 ppid: 28252, pid: 28290, t: 0.5618s scanners: clamav: 0.88.4/m:40/d:1722 Received: from unknown (HELO WEB) (dev.manager/spazio3d.net@151.25.105.44) by smtp5.aruba.it with SMTP; 5 Dec 2006 16:02:43 -0000 Message-ID: <00e201c71886$e7ef1c40$76671997@WEB> From: "dev.department" To: Subject: Hide structure Date: Tue, 5 Dec 2006 17:01:17 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00BD_01C7188E.FADE3E00" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4927.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 X-Spam-Rating: smtp5.aruba.it 1.6.2 0/1000/N X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.185 tagged_above=0 required=5 tests=BAYES_40, DEAR_SOMETHING, FORGED_RCVD_HELO, HTML_50_60, HTML_MESSAGE X-Spam-Level: ** X-Archive-Number: 200612/169 X-Sequence-Number: 23961 This is a multi-part message in MIME format. ------=_NextPart_000_00BD_01C7188E.FADE3E00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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... Looking forward to your answer, Best regards Quagliotto Davide ------=_NextPart_000_00BD_01C7188E.FADE3E00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 
 
 
Dear Sirs,
 
We're a softwarehouse who is = considering the=20 possibility to insert the PostgreSQL 8.1 database in our=20 software.
How can we prevent the visualization of = structure=20 and data (tables, views, etc.) of a PostgreSQL 8.1 database? Keep = present=20 that the person who has installed PostgreSQL 8.1  is the=20 administrator of the PC in which it it installed, and so he could modify = the=20 configuration files of PostgreSQL 8.1 server (for example files as=20 "pg_hba.conf", "postgresql.conf", ecc.).
 
We've also seen that command "pg_dump" allows to visualize all = structures=20 and data of a database simply knowing the user name and not his=20 password...
 
Looking forward to your = answer,
 
Best regards
Quagliotto = Davide
 
 
------=_NextPart_000_00BD_01C7188E.FADE3E00-- From smarlowe@g2switchworks.com Tue Dec 12 18:38:45 2006 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.