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 804A5D1E5CF for ; Tue, 4 May 2004 16:13:35 -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 12213-01 for ; Tue, 4 May 2004 16:13:16 -0300 (ADT) Received: from smtp3.es.uci.edu (smtp3.es.uci.edu [128.200.80.6]) by svr1.postgresql.org (Postfix) with ESMTP id 7AA81D1E12D for ; Tue, 4 May 2004 16:13:14 -0300 (ADT) Received: from DD16YQ31 (mmg124.mmg.uci.edu [128.195.176.124]) by smtp3.es.uci.edu (8.12.8/8.12.8) with ESMTP id i44JCwGj023082 for ; Tue, 4 May 2004 12:13:00 -0700 Message-Id: <200405041913.i44JCwGj023082@smtp3.es.uci.edu> From: "Richard Colman" To: Subject: Limiting user access to a view only Date: Tue, 4 May 2004 12:12:58 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Thread-Index: AcQyC89fNWucYwtPSBa7Q/TkrrQ/vA== X-NACS_ES-MailScanner: No viruses found 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/41 X-Sequence-Number: 13357 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. Richard Colman Institute for Genomics and Bioinformatics 949-824-1816, 701-5330 colman@uci.edu