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 77C97DA7CE for ; Sun, 6 Nov 2005 17:54:07 -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 14647-07 for ; Sun, 6 Nov 2005 21:54:05 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.205]) by svr1.postgresql.org (Postfix) with ESMTP id 55C64D6862 for ; Sun, 6 Nov 2005 17:54:06 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i4so552070wra for ; Sun, 06 Nov 2005 13:54:08 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=J9szXkz1fEDwQaZHheiKjDgi933+LU0Sld7rhBl5/sEK6y1u9JeeKCiuyLpBGM6X7D+39oyaQdCDHP4arIkB2BLbDE3Wheq9EfgwlRjpi+bcw2HrjYW2nrVEQG7SJ0MB4U1jxcfZkAvXqXdXSU5lxcXCjEyqH4TEZPPa32vaRwg= Received: by 10.54.60.9 with SMTP id i9mr1041730wra; Sun, 06 Nov 2005 13:54:08 -0800 (PST) Received: by 10.54.133.7 with HTTP; Sun, 6 Nov 2005 13:54:08 -0800 (PST) Message-ID: <84d3067d0511061354i56eded6fhd0a0360da2ddaee5@mail.gmail.com> Date: Mon, 7 Nov 2005 10:54:08 +1300 From: Colin Taylor To: pgsql-admin@postgresql.org Subject: read only user MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_15724_2886226.1131314048489" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.334 required=5 tests=[AWL=-0.309, HTML_00_10=0.642, HTML_MESSAGE=0.001] X-Spam-Score: 0.334 X-Spam-Level: X-Archive-Number: 200511/100 X-Sequence-Number: 19473 ------=_Part_15724_2886226.1131314048489 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 wa= y to do this with out explictly granting the SELECT privilege on every table? Thanks and regards, Colin. ------=_Part_15724_2886226.1131314048489 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 w= ay to do this with out explictly granting the SELECT privilege on every tab= le?

Thanks and regards,
Colin.
------=_Part_15724_2886226.1131314048489--