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 8BCAF52D42 for ; Wed, 30 Mar 2005 17:47:52 +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 55298-08 for ; Wed, 30 Mar 2005 16:47:42 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 5146753B9E for ; Wed, 30 Mar 2005 17:47:41 +0100 (BST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j2UGlVDW002549 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Wed, 30 Mar 2005 09:47:34 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j2UGlVAV035827; Wed, 30 Mar 2005 09:47:31 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j2UGlVZ6035826; Wed, 30 Mar 2005 09:47:31 -0700 (MST) (envelope-from mfuhr) Date: Wed, 30 Mar 2005 09:47:31 -0700 From: Michael Fuhr To: John DeSoi Cc: Zouari Fourat , pgsql-admin@postgresql.org Subject: Re: problems with user rights Message-ID: <20050330164731.GB35744@winnie.fuhr.org> References: <621eda8a050328053256ac576b@mail.gmail.com> <621eda8a0503300043711fdaf3@mail.gmail.com> <2EE9A7E0-A11C-11D9-A2E3-000A95B03262@pgedit.com> <621eda8a0503300717ca9a63a@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/487 X-Sequence-Number: 16985 On Wed, Mar 30, 2005 at 11:14:38AM -0500, 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. ...like using pg_hba.conf to control who's allowed to connect to each database. If you don't want people to query the system catalogs for a particular database, then don't allow them to connect to that database (there are a few shared catalogs that anybody can query, however). The db_user_namespace configuration variable might help with managing access, but the documentation says that it's "intended as a temporary measure until a complete solution is found," so caveat administrator. -- Michael Fuhr http://www.fuhr.org/~mfuhr/