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 28B8D537DF for ; Wed, 30 Mar 2005 17:43:56 +0100 (BST) 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 52755-10 for ; Wed, 30 Mar 2005 16:43:55 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id DE64F537D4 for ; Wed, 30 Mar 2005 17:43:53 +0100 (BST) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 30 Mar 2005 10:43:52 -0600 Subject: Re: problems with user rights From: Scott Marlowe To: John DeSoi Cc: Zouari Fourat , pgsql-admin@postgresql.org In-Reply-To: References: <621eda8a050328053256ac576b@mail.gmail.com> <621eda8a0503300043711fdaf3@mail.gmail.com> <2EE9A7E0-A11C-11D9-A2E3-000A95B03262@pgedit.com> <621eda8a0503300717ca9a63a@mail.gmail.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1112201032.31277.40.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 30 Mar 2005 10:43:52 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/484 X-Sequence-Number: 16982 On Wed, 2005-03-30 at 10:14, John DeSoi wrote: > On Mar 30, 2005, at 10:17 AM, Zouari Fourat wrote: > > > is it really secure in a shared hosting environnement case ? > > do you advise me to offer pgsql in a shared hosting ? > > You can do all of the necessary things to control access to the > databases. You just can't hide that they exist if you provide a way to > directly query the database. There are may companies providing shared > hosting. I'm not aware of any security issues. My preferred way to setup accecss is to use the sameuser setting in pg_hba.conf, which lets a user only connect to the database of their name. Nicely partitions the server with minimum configuration needed.