X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 59F15D1F2E4 for ; Wed, 5 May 2004 14:25:39 -0300 (ADT) 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 49773-10 for ; Wed, 5 May 2004 14:25:10 -0300 (ADT) Received: from curie.credativ.org (credativ.com [217.160.209.18]) by svr1.postgresql.org (Postfix) with ESMTP id A97BBD1F412 for ; Wed, 5 May 2004 14:10:31 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by curie.credativ.org (Postfix) with ESMTP id 2032A55EF0; Wed, 5 May 2004 19:10:29 +0200 (CEST) Received: from colt.pezone.net (dsl-082-082-233-019.arcor-ip.net [82.82.233.19]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by curie.credativ.org (Postfix) with ESMTP id 2FF8D55EEC; Wed, 5 May 2004 19:10:28 +0200 (CEST) From: Peter Eisentraut To: "Richard Colman" , Subject: Re: Limiting user access to a view only Date: Wed, 5 May 2004 19:10:26 +0200 User-Agent: KMail/1.5.1 References: <200405041913.i44JCwGj023082@smtp3.es.uci.edu> In-Reply-To: <200405041913.i44JCwGj023082@smtp3.es.uci.edu> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200405051910.26469.peter_e@gmx.net> X-Virus-Scanned: by AMaViS at credativ.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_DSBL X-Spam-Level: * X-Archive-Number: 200405/49 X-Sequence-Number: 13365 Richard Colman wrote: > How would I set up a new user on PostgreSQL so that the new user is > limited to reading a particular view, and can do nothing else. A new user normally can't do anything. Just grant the privileges on the view to him. You may also want to revoke all permissions on databases and schemas, some of which are set to allow everything by default. The GRANT manual page contains more information and pointers.