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

 I started again I made a new database location and did an initdb. created a
 new database in that location called foo1 then created a user called user1
 and a table called foo revoked all on foo from public and grant all on foo
 to user1 and still I get this error.

 My make and gcc are

 make -v
 GNU Make version 3.79.1, by Richard Stallman and Roland McGrath.
 Built for i686-pc-linux-gnu

 gcc -v
 Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs
 gcc version 2.95.3 20010315 (SuSE)

 My configure options are as
 follows. --with-perl --with=maxbackends=100 --enable-odbc

 I had no errors on the build or install I didn't install the version of
 postgresql that came with SuSE as I didn't want it to interfere with this
 build.

 template1=# create database foo1;
 CREATE DATABASE
 template1=# \c foo1
 You are now connected to database foo1.
 foo1=# create user user1;
 CREATE USER
 foo1=# create table foo(f1 int);
 revoke all on foo from public;
 grant all on foo to user1;
 CREATE
 REVOKE
 GRANT
 foo1=# \c - user1
 You are now connected as new user user1.
 foo1=>select * from foo;
 ERROR:  aclcheck: first entry in ACL is not 'world' entry

> ----- Original Message -----
> From: "Tom Lane" <tgl@sss.pgh.pa.us>
> To: "Phil Geer" <philg@gearcc.com>
> Sent: Sunday, March 10, 2002 11:45 AM
> Subject: Re: [GENERAL] ERROR: aclcheck: first entry in ACL is Not 'world'
> entry
>

 > So if you start as superuser and do
 >
 > create table foo(f1 int);
 > revoke all on foo from public;
 > grant all on foo to user1;
 > \c - user1
 > select * from foo;
 >
 > you get that aclcheck failure?
 >
 > This doesn't happen for me, and we'd surely have heard about it if it
 > were happening for other people.  The only thing I can think is that
 > you have a broken installation.  You said you compiled from source ---
 > what compiler did you use exactly, and what configure options?
 >
 > regards, tom lane
 >
 >