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@sss.pgh.pa.us>
To: "Phil Geer" <philg@gearcc.com>
Cc: <pgsql-general@postgresql.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@gearcc.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
>
>