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

It did this from the start all I did was take a dump from my 7.1.3 database
and load it on my newly build 7.2 server. Log in as anyone other then the
super user and you get this error.

I did try to revoke all user privileges then grant them again just to see if
it helped but that didn't do anything.

Here is a cut from my dump file on my 7.1.3 server..

--- cut ---
--
-- TOC Entry ID 15 (OID 18981)
--
-- Name: count Type: TABLE Owner: philg
--

CREATE TABLE "count" (
"page_name" character varying(255),
"hits" integer,
"page_id" integer DEFAULT nextval('count_page_id_seq'::text) NOT NULL,
Constraint "count_pkey" Primary Key ("page_id")
);

--
-- TOC Entry ID 16 (OID 18981)
--
-- Name: count Type: ACL Owner:
--

REVOKE ALL on "count" from PUBLIC;
GRANT ALL on "count" to "user1";
GRANT INSERT,UPDATE,DELETE,SELECT on "count" to "user2";

--- cut ---

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Phil Geer" <philg(at)gearcc(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Sunday, March 10, 2002 12:51 AM
Subject: Re: [GENERAL] ERROR: aclcheck: first entry in ACL is Not 'world'
entry

> "Phil Geer" <philg(at)gearcc(dot)com> writes:
> > I'm getting the following error message.
> > ERROR: aclcheck: first entry in ACL is not 'world' entry
>
> That shouldn't happen. Can you show us the sequence of grant and/or
> revoke steps that got the table into that state?
>
> regards, tom lane
>
>