problem with GRANT postgres 8.0.4

From: Jacek Balcerski <balcersk(at)wsisiz(dot)edu(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: problem with GRANT postgres 8.0.4
Date: 2005-11-22 14:39:51
Message-ID: 43832DB7.50403@wsisiz.edu.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

There are two tables

article_reviewers
Column | Type | Modifiers
-------------+---------+-----------
article_id | integer | not null
reviewer_id | integer | not null
Foreign-key constraints:
"$1" FOREIGN KEY (reviewer_id) REFERENCES reviewers(person_id)

reviewers
Column | Type | Modifiers
-----------+---------+-----------
person_id | integer | not null
status | text |
keywords | text |
Indexes:
"reviewers_pkey" PRIMARY KEY, btree (person_id)
Foreign-key constraints:
"$1" FOREIGN KEY (person_id) REFERENCES persons(id)

When I try to execute sql statement:

INSERT INTO article_reviewers (article_id, reviewer_id) VALUES (876,569);

ERROR: permission denied for relation reviewers
KONTEKST: SQL statement "SELECT 1 FROM ONLY "public"."reviewers" x
WHERE "person_id" = $1 FOR UPDATE OF x"

In person table there is ofcourse person with id=569.
User is super user and I did GRANT ALL on ALL TABLES :
public | article_reviewers | table |
{control=r/control,balcer=arwdRxt/control}
public | articles | table |
{control=r/control,balcer=arwdRxt/control}
public | persons | table |
{control=r/control,balcer=arwdRxt/control}

What is wrong, sorry if this is stupid question.
Jacek

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Howard Cole 2005-11-22 15:01:22 How to trim Bytea fields
Previous Message A.j. Langereis 2005-11-22 14:11:52 Re: Rule appears not to fire on insert w/ "except"