Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by postgresql.org (8.11.3/8.11.4) with SMTP id fA5Fdtq53785 for ; Mon, 5 Nov 2001 10:39:56 -0500 (EST) (envelope-from ch@rodos.fzk.de) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Mon Nov 05 16:39:56 2001 +0100 Received: by rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id QAA11162; Mon, 5 Nov 2001 16:42:28 +0100 (MET) From: Haller Christoph Message-Id: <200111051538.QAA07184@rodos> Subject: table permissions II To: olebedev@waterford.org Date: Mon, 05 Nov 2001 16:38:13 MET Cc: pgsql-sql@postgresql.org In-Reply-To: <3BE1B8CC.38221E54@waterford.org>; from "Oleg Lebedev" at Nov 5, 101 10:03 am X-Mailer: Elm [revision: 212.4] X-Archive-Number: 200111/52 X-Sequence-Number: 5436 I had similar problems, especially when granting DELETE permissions insert commands worked as intended. And I did not mess with any config files. Regards, Christoph > Hi everybody, > I can't seem to figure this one out. > I have a superuser root and a regular user oleg. I am trying to insert a > new row in table Set, which references table Activity, being logged in > as root. I get an error saying: > activity: Permission denied. > This is very weird because root has all the permissions on every table > in the database. Even more strange is that as soon as I grant DELETE > privilege to user oleg, the problem disappears and I can add a row to > the Set table. > Does anybody know how to solve this problem? > Should I upgrade my PostgreSQL version? I am currently using v 7.1.2