Skip site navigation (1) Skip section navigation (2)

Re: updateble views

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: thiemo <thiemo(at)gmx(dot)ch>, pgNovice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: updateble views
Date: 2002-04-19 23:26:23
Message-ID: web-1378205@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2002-04-19 23:31:40
Subject: Re: updateble views
Previous:From: thiemoDate: 2002-04-19 23:00:32
Subject: updateble views

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group