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

updateble views

From: thiemo <thiemo(at)gmx(dot)ch>
To: pgNovice <pgsql-novice(at)postgresql(dot)org>
Subject: updateble views
Date: 2002-04-19 23:00:32
Message-ID: 40B03115-53E9-11D6-8805-000A27D62F9E@gmx.ch (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Josh BerkusDate: 2002-04-19 23:26:23
Subject: Re: updateble views
Previous:From: Vincent DOYELLEDate: 2002-04-19 19:36:36
Subject: Permission denied when executing a query from a file

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