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
>
>
