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?
pgsql-novice by date
|Next:||From: Josh Berkus||Date: 2002-04-19 23:26:23|
|Subject: Re: updateble views|
|Previous:||From: Vincent DOYELLE||Date: 2002-04-19 19:36:36|
|Subject: Permission denied when executing a query from a file|