Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 8A1BC9FB719 for ; Wed, 21 Mar 2007 14:42:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 14312-06 for ; Wed, 21 Mar 2007 14:42:33 -0300 (ADT) X-Greylist: delayed 01:00:06.406051 by SQLgrey-1.7.4 Received: from osl1smout1.broadpark.no (osl1smout1.broadpark.no [80.202.4.58]) by postgresql.org (Postfix) with ESMTP id 1E6739FA589 for ; Wed, 21 Mar 2007 14:42:35 -0300 (ADT) Received: from osl1sminn1.broadpark.no ([80.202.4.59]) by osl1smout1.broadpark.no (Sun Java System Messaging Server 6.1 HotFix 0.05 (built Oct 21 2004)) with ESMTP id <0JF9006REIER8W90@osl1smout1.broadpark.no> for pgsql-admin@postgresql.org; Wed, 21 Mar 2007 17:42:27 +0100 (CET) Received: from [10.0.0.3] ([80.202.18.239]) by osl1sminn1.broadpark.no (Sun Java System Messaging Server 6.1 HotFix 0.05 (built Oct 21 2004)) with ESMTP id <0JF9005M9IERVYX0@osl1sminn1.broadpark.no> for pgsql-admin@postgresql.org; Wed, 21 Mar 2007 17:42:27 +0100 (CET) Date: Wed, 21 Mar 2007 17:42:25 +0100 From: "Morten W. Petersen" Subject: Read-only access to a database To: pgsql-admin@postgresql.org Message-id: <46016071.3000304@nidelven-it.no> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT User-Agent: Thunderbird 1.5.0.10 (X11/20070306) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/149 X-Sequence-Number: 24973 Hi, I'd like to create a user that has read-only access to a database. I've read the docs and fumbled around a bit (even tried to use phppgadmin) - but nothing works. "CREATE USER username" is about as far as I've gotten. Which other commands would I have to use to enable read-only access to a database? Thanks, Morten