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 4C1A156796
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 22 Mar 2005 19:55:04 +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 54640-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 22 Mar 2005 19:55:03 +0000 (GMT)
Received: from cheech.nmsu.edu (cheech.NMSU.Edu [128.123.34.14])
	by svr1.postgresql.org (Postfix) with ESMTP id A79745674B
	for <pgsql-sql@postgresql.org>; Tue, 22 Mar 2005 19:55:02 +0000 (GMT)
Received: (from nobody@localhost)
	by cheech.nmsu.edu (8.11.6/8.11.6) id j2MJt3320280
	for pgsql-sql@postgresql.org; Tue, 22 Mar 2005 12:55:03 -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 12:55:03 -0700
Message-ID: <1111521303.42407817befd2@webmail.nmsu.edu>
Date: Tue, 22 Mar 2005 12:55:03 -0700
From: subhash@nmsu.edu
To: pgsql-sql@postgresql.org
Subject: Permissions on tables
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.701 tagged_above=0 required=5 tests=AWL,
 NO_REAL_NAME
X-Spam-Level: 
X-Archive-Number: 200503/340
X-Sequence-Number: 20819

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.