Re: problem with GRANT postgres 8.0.4 - Mailing list 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