problem with GRANT postgres 8.0.4
| От | Jacek Balcerski |
|---|---|
| Тема | problem with GRANT postgres 8.0.4 |
| Дата | |
| Msg-id | 43832DB7.50403@wsisiz.edu.pl обсуждение исходный текст |
| Ответы |
Re: problem with GRANT postgres 8.0.4
|
| Список | 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
В списке pgsql-general по дате отправления: