Re: ERROR: aclcheck: first entry in ACL is Not 'world' entry
От | Phil Geer |
---|---|
Тема | Re: ERROR: aclcheck: first entry in ACL is Not 'world' entry |
Дата | |
Msg-id | 01fb01c1c7fa$67f1dd20$4ac16dd8@offback2000 обсуждение исходный текст |
Ответ на | ERROR: aclcheck: first entry in ACL is Not 'world' entry ("Phil Geer" <philg@gearcc.com>) |
Список | pgsql-general |
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 > >
В списке pgsql-general по дате отправления: