X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3E6CAD1B457 for ; Tue, 25 Nov 2003 17:27:36 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 04588-06 for ; Tue, 25 Nov 2003 13:27:04 -0400 (AST) Received: from starbucks.sunwave.net (Helium.sunwave.net [64.141.16.15]) by svr1.postgresql.org (Postfix) with ESMTP id 82CDAD1B431 for ; Tue, 25 Nov 2003 13:27:05 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by starbucks.sunwave.net (Postfix) with ESMTP id 7BFE3178004; Tue, 25 Nov 2003 12:27:05 -0500 (EST) From: Michael A Nachbaur To: Tom Lane Subject: Re: "Permission denied" on view Date: Tue, 25 Nov 2003 09:27:05 -0800 User-Agent: KMail/1.5 Cc: pgsql-sql@postgresql.org References: <200311250855.13335.mike@nachbaur.com> <28490.1069780179@sss.pgh.pa.us> In-Reply-To: <28490.1069780179@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200311250927.05270.mike@nachbaur.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/285 X-Sequence-Number: 16100 On Tuesday 25 November 2003 09:09 am, Tom Lane wrote: > Michael A Nachbaur writes: > > scamp=> select * from Dialup.UserGroup; > > ERROR: dialup: permission denied > > You haven't granted USAGE permission on the "dialup" schema to this > user. You need that in addition to select permission on the view itself. Thank you; apparently I didn't RTFM closely enough. /me goes sheepishly back to work -- /* Michael A. Nachbaur * http://nachbaur.com/pgpkey.asc */ "`Credit?' he said. `Aaaargggh...' These two words are usually coupled together in the Old Pink Dog Bar."