X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1AD4ADA5BE for ; Wed, 9 Nov 2005 22:51:58 -0400 (AST) 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 95242-02 for ; Thu, 10 Nov 2005 02:51:53 +0000 (GMT) X-Greylist: delayed 00:06:39.590138 by SQLgrey- Received: from nswrdn.com.au (unknown [150.101.119.210]) by svr1.postgresql.org (Postfix) with SMTP id D3888D9CEB for ; Wed, 9 Nov 2005 22:51:54 -0400 (AST) Received: (qmail 18457 invoked by uid 404); 10 Nov 2005 02:45:17 -0000 Received: from wkaan@nswrdn.com.au by bessie.nswrdn.com.au with qmail-scanner; 10 Nov 2005 02:45:12 -0000 Received: from pc-00220.nswrdn.com.au (10.0.0.220) by bessie.nswrdn.com.au (10.0.0.4) with ESMTP; 10 Nov 2005 02:45:12 -0000 Subject: Re: read only user From: Walter Kaan To: Colin Taylor Cc: pgsql-admin@postgresql.org In-Reply-To: <84d3067d0511061354i56eded6fhd0a0360da2ddaee5@mail.gmail.com> References: <84d3067d0511061354i56eded6fhd0a0360da2ddaee5@mail.gmail.com> Content-Type: text/plain Organization: NSW Rural Doctors Network Date: Thu, 10 Nov 2005 13:45:13 +1100 Message-Id: <1131590714.7591.14.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.013 required=5 tests=[AWL=0.013] X-Spam-Score: 0.013 X-Spam-Level: X-Archive-Number: 200511/111 X-Sequence-Number: 19484 Hi Colin, If its a one-off I usually do this in pgadmin3 by right clicking on the schema and doing the grant wizard from there. Regards Walter On Mon, 2005-11-07 at 10:54 +1300, Colin Taylor wrote: > Hi there, Ive google and searched the lists but havent found detailed > instructions on how to give a user readly access to a schema. Is there > a way to do this with out explictly granting the SELECT privilege on > every table? > > Thanks and regards, > Colin. -- Walter Kaan IM/IT Manager NSW Rural Doctors Network www.nswrdn.com.au