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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

> 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>;

-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-2017 The PostgreSQL Global Development Group