> 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?
GRANT SELECT, UPDATE ON <sequence_name> TO <user>;
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2002-04-19 23:31:40|
|Subject: Re: updateble views |
|Previous:||From: thiemo||Date: 2002-04-19 23:00:32|
|Subject: updateble views|