Re: problem with GRANT postgres 8.0.4

From: Richard Huxton <dev(at)archonet(dot)com>
To: balcersk(at)wsisiz(dot)edu(dot)pl
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problem with GRANT postgres 8.0.4
Date: 2005-11-22 15:22:36
Message-ID: 438337BC.3030000@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2005-11-22 15:23:53 Re: How to trim Bytea fields
Previous Message Richard Huxton 2005-11-22 15:20:32 Re: Java, postgres and jasper help