Permissions on tables and views - Mailing list pgsql-hackers

From subhash@nmsu.edu
Subject Permissions on tables and views
Date
Msg-id 1111522189.42407b8d28b7a@webmail.nmsu.edu
Whole thread Raw
List pgsql-hackers
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. 


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Failed to re-find parent key
Next
From: Tom Lane
Date:
Subject: Re: Proposal: OUT parameters for plpgsql