From: Michael Fuhr <mike@fuhr.org>
To: subhash@nmsu.edu
Cc: PostgreSQL SQL <pgsql-sql@postgresql.org>
Subject: Re: Permissions on tables and views
Date: Tue, 22 Mar 2005 14:46:17 -0700
Message-ID: <20050322214617.GA97500@winnie.fuhr.org> (raw)
In-Reply-To: <1111526888.42408de81a042@webmail.nmsu.edu>
References: <1111526888.42408de81a042@webmail.nmsu.edu>
On Tue, Mar 22, 2005 at 02:28:08PM -0700, subhash@nmsu.edu wrote:
> 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 ?
Did you grant insert and update permission on the view? Does the
underlying table have a sequence? If so, did you grant update
permission on it?
If you still have trouble, then please post a small, self-contained
example that demonstrates the problem, including the exact text of
any error messages.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, subhash@nmsu.edu
Subject: Re: Permissions on tables and views
In-Reply-To: <20050322214617.GA97500@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox