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 по дате отправления: