ERROR: aclcheck: first entry in ACL is Not 'world' entry

From: "Phil Geer" <philg(at)gearcc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: aclcheck: first entry in ACL is Not 'world' entry
Date: 2002-03-10 05:31:25
Message-ID: 01d601c1c7f4$d25ea450$4ac16dd8@offback2000
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

I'm getting the following error message.

ERROR: aclcheck: first entry in ACL is not 'world' entry

This is on a new server I'm setting up it is postgresql 7.2 compiled from
source on SuSE Linux 7.2.
I then load a database that I dumped from postgresql 7.1.3 on my production
server.

I've gone back and revoke everyone's table privileges on all the tables and
then granted the privileges again. The only one that can seem to do selects
on the tables is the superuser. Anyone else gets this error message. One
thing I noticed was looking in the pg_class table in 7.1.3 the relacl column
the entries look like this
{"=", "user1=arw"} and in 7.2 it look like this { =, user1=arw }

I'm not sure the quotes in 7.1.3 should be there in 7.2 but if so how do I
get them in.

Thanks
Phil

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-03-10 05:46:49 Re: postgres 7.2 make check problem
Previous Message Michael 2002-03-10 03:33:05 postgres 7.2 make check problem