X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2DA1D9DCCDC for ; Tue, 29 Nov 2005 22:36:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09300-10 for ; Tue, 29 Nov 2005 22:37:00 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.200]) by postgresql.org (Postfix) with ESMTP id 9F8AA9DCCD4 for ; Tue, 29 Nov 2005 22:36:55 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i1so2386402wra for ; Tue, 29 Nov 2005 18:37:00 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=p/O7YHJZT5RM1Kz6VES4kTH+FZQQ2TBEcQeIO6oYnWXTbu2Paic7miXoPm0JY7P1dR0T+1D9Pjb79s8wWyCJbBJJbInyJlpmTky1kgERCccATm2EWHKQf2Gd1o8HXacIpmU9Yx5aJsXsO0x9G00yGWm64mvFASiw2/wegnm2Rc4= Received: by 10.54.60.19 with SMTP id i19mr16545wra; Tue, 29 Nov 2005 18:36:59 -0800 (PST) Received: by 10.54.118.11 with HTTP; Tue, 29 Nov 2005 18:36:59 -0800 (PST) Message-ID: <65029d820511291836m34e12bceucbba4c120a2a8d9f@mail.gmail.com> Date: Tue, 29 Nov 2005 18:36:59 -0800 From: Dan Tenenbaum To: pgsql-admin@postgresql.org Subject: Re: the "users" group and restricting privileges In-Reply-To: <11392.1133310091@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6615_31879269.1133318219526" References: <65029d820511291530mc4a0f62nc1de5cf58d110765@mail.gmail.com> <11392.1133310091@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.322 required=5 tests=[AWL=0.321, HTML_MESSAGE=0.001] X-Spam-Score: 0.322 X-Spam-Level: X-Archive-Number: 200511/341 X-Sequence-Number: 19714 ------=_Part_6615_31879269.1133318219526 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Thanks to both you and Jim--this was the missing piece that made things work. On 11/29/05, Tom Lane wrote: > > Dan Tenenbaum writes: > > ERROR: permission denied for schema myschema > > What do I need to do to get the correct permissions? > > GRANT USAGE ON SCHEMA myschema TO whoever > > Schema access is comparable to directory access in a filesystem: if you > can't look into the directory, it doesn't matter what privileges you > might have for the individual files in it. > > regards, tom lane > ------=_Part_6615_31879269.1133318219526 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Thanks to both you and Jim--this was the missing piece that made things wor= k.



------=_Part_6615_31879269.1133318219526--