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 AEFE553461 for ; Wed, 30 Mar 2005 16:18:03 +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 26276-04 for ; Wed, 30 Mar 2005 15:17:57 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.194]) by svr1.postgresql.org (Postfix) with ESMTP id D4AC753442 for ; Wed, 30 Mar 2005 16:17:55 +0100 (BST) Received: by wproxy.gmail.com with SMTP id 69so181488wra for ; Wed, 30 Mar 2005 07:17:58 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=hhwOl5rTEsp9jU7bd7M/uxJ5iwo5PItmP/dokLldtW8lUtz7gK5zuXxRsdaTOzCparAJk+VwB64C4tcfARfND+FYolP2z3P/i0yVTZDmU/4vXQq7og3MbfvdLyDeSyzzouPEnagfyMf3/rOrVkPnsL1Kot1vdwRyDkCzgXUWSEk= Received: by 10.54.24.48 with SMTP id 48mr515498wrx; Wed, 30 Mar 2005 07:17:56 -0800 (PST) Received: by 10.54.40.4 with HTTP; Wed, 30 Mar 2005 07:17:54 -0800 (PST) Message-ID: <621eda8a0503300717ca9a63a@mail.gmail.com> Date: Wed, 30 Mar 2005 17:17:54 +0200 From: Zouari Fourat Reply-To: Zouari Fourat To: John DeSoi Subject: Re: problems with user rights Cc: pgsql-admin@postgresql.org In-Reply-To: <2EE9A7E0-A11C-11D9-A2E3-000A95B03262@pgedit.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit References: <621eda8a050328053256ac576b@mail.gmail.com> <621eda8a0503300043711fdaf3@mail.gmail.com> <2EE9A7E0-A11C-11D9-A2E3-000A95B03262@pgedit.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.214 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200503/478 X-Sequence-Number: 16976 is it really secure in a shared hosting environnement case ? do you advise me to offer pgsql in a shared hosting ? On Wed, 30 Mar 2005 08:04:00 -0500, John DeSoi wrote: > > i've just added a new user called xxx : > > > > create user xxx with password zzz; > > > > now am creating it's database : > > > > create database db_xxx with owner xxx; > > > > it works fine althought when logging with the user xxx i can still > > view other databases contents especially pg_catalog schems. > > > > is it the right way to add a user ? am i wrong ? > > i dont want to let my new user view the others databases on the server. > > Viewing the information in the system catalogs is open to all users. > There is not a way to hide it unless you build an interface on top of > PostgreSQL that limits the queries the user can execute. > > John DeSoi, Ph.D. > http://pgedit.com/ > Power Tools for PostgreSQL > >