X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8869D52A6C for ; Tue, 22 Mar 2005 21:28:08 +0000 (GMT) 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 86042-06 for ; Tue, 22 Mar 2005 21:28:07 +0000 (GMT) Received: from cheech.nmsu.edu (cheech.NMSU.Edu [128.123.34.14]) by svr1.postgresql.org (Postfix) with ESMTP id 16C9F52A64 for ; Tue, 22 Mar 2005 21:28:05 +0000 (GMT) Received: (from nobody@localhost) by cheech.nmsu.edu (8.11.6/8.11.6) id j2MLS8P22061 for pgsql-sql@postgresql.org; Tue, 22 Mar 2005 14:28:08 -0700 Received: from 128.123.94.50 ( [128.123.94.50]) as user subhash@imap.nmsu.edu by webmail.nmsu.edu with HTTP; Tue, 22 Mar 2005 14:28:08 -0700 Message-ID: <1111526888.42408de81a042@webmail.nmsu.edu> Date: Tue, 22 Mar 2005 14:28:08 -0700 From: subhash@nmsu.edu To: PostgreSQL SQL Subject: Permissions on tables and views MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.0 X-Originating-IP: 128.123.94.50 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.309 tagged_above=0 required=5 tests=AWL, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200503/305 X-Sequence-Number: 20784 Hi, I have a requirement where I have a table and a view on top of it. I want to make some changes so that a user in a given group would be able to insert/update only on the view (ofcourse i have a rule which inserts/updates the table) but not on the underlying table. I tried revoke the insert/update permissions on the table, but it fails even the inserts/updates on the view. How can i set these permissions ? Thanks, Subhash.