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