Re: problem with GRANT postgres 8.0.4

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: problem with GRANT postgres 8.0.4
Дата
Msg-id 438337BC.3030000@archonet.com
обсуждение исходный текст
Ответ на problem with GRANT postgres 8.0.4  (Jacek Balcerski <balcersk@wsisiz.edu.pl>)
Список pgsql-general
Jacek Balcerski wrote:
> 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}

I don't see table "reviewers" in this list, which is the table the error
statement mentions.
--
   Richard Huxton
   Archonet Ltd

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Java, postgres and jasper help
Следующее
От: Joe Conway
Дата:
Сообщение: Re: How to trim Bytea fields