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 C16ADD1F10B for ; Wed, 5 May 2004 12:56:48 -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 07120-01 for ; Wed, 5 May 2004 12:56:27 -0300 (ADT) Received: from jimsun.LinxNet.com (jimsun.linxnet.com [64.32.196.134]) by svr1.postgresql.org (Postfix) with ESMTP id A84F8D1DCA5 for ; Wed, 5 May 2004 12:56:26 -0300 (ADT) Received: by jimsun.LinxNet.com (Postfix, from userid 332) id DC0D84310; Wed, 5 May 2004 11:56:25 -0400 (EDT) To: pgsql-admin@postgresql.org Subject: Re: Limiting user access to a view only Reply-To: pgsql-admin@postgresql.org Message-Id: <20040505155625.DC0D84310@jimsun.LinxNet.com> Date: Wed, 5 May 2004 11:56:25 -0400 (EDT) From: jseymour@LinxNet.com (Jim Seymour) X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/47 X-Sequence-Number: 13363 > > I am a novice in this area. > > 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. > > Help greatly appreciated. You will find these handy, no doubt... http://www.postgresql.org/docs/7.4/static/tutorial.html http://www.postgresql.org/docs/7.4/static/sql-createuser.html http://www.postgresql.org/docs/7.4/static/sql-grant.html Jim