pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Permissions on tables and views
2+ messages / 2 participants
[nested] [flat]

* Permissions on tables and views
@ 2005-03-22 21:28  subhash@nmsu.edu
  0 siblings, 1 reply; 2+ messages in thread

From: subhash@nmsu.edu @ 2005-03-22 21:28 UTC (permalink / raw)
  To: pgsql-sql

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. 



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Permissions on tables and views
@ 2005-03-22 21:46  Michael Fuhr <mike@fuhr.org>
  parent: subhash@nmsu.edu
  0 siblings, 0 replies; 2+ messages in thread

From: Michael Fuhr @ 2005-03-22 21:46 UTC (permalink / raw)
  To: subhash@nmsu.edu; +Cc: pgsql-sql

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/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2005-03-22 21:46 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-22 21:28 Permissions on tables and views subhash@nmsu.edu
2005-03-22 21:46 ` Michael Fuhr <mike@fuhr.org>

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