Re: updateble views - Mailing list pgsql-novice

From Josh Berkus
Subject Re: updateble views
Date
Msg-id web-1378205@davinci.ethosmedia.com
Whole thread Raw
In response to updateble views  (thiemo <thiemo@gmx.ch>)
List pgsql-novice
Thiemo,

> I have a table that I want users to access to only through a view.
> For the inserts, I have defined a rule.  I granted insert rights on
> the base table and view as well as select rights on the view to the
> users. However, a users trying an insert on the view gets an "Error
> while executing statement: ERROR:  s_pwd.nextval: you don't have
> permissions to set sequence s_pwd". Is there a right I need to grant
> to the users regarding the sequence?

Yes.
GRANT SELECT, UPDATE ON <sequence_name> TO <user>;

-Josh Berkus

pgsql-novice by date:

Previous
From: thiemo
Date:
Subject: updateble views
Next
From: Tom Lane
Date:
Subject: Re: updateble views