From: subhash@nmsu.edu
To: PostgreSQL SQL <pgsql-sql@postgresql.org>
Subject: Permissions on tables and views
Date: Tue, 22 Mar 2005 14:28:08 -0700
Message-ID: <1111526888.42408de81a042@webmail.nmsu.edu> (raw)
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.
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: subhash@nmsu.edu
Subject: Re: Permissions on tables and views
In-Reply-To: <1111526888.42408de81a042@webmail.nmsu.edu>
* 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