updateble views

Hi,


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?


Thx


Thiemo

<fontfamily><param>Helvetica</param>

--

Thiemo Kellner

Tösstalstrasse 146

CH-8400 Winterthur

</fontfamily>Hi,

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?

Thx

Thiemo

--
Thiemo Kellner
Tösstalstrasse 146
CH-8400 Winterthur