Received: from mailserv.hub.org (mailserv.hub.org [216.126.84.253]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA2DN2q09303 for ; Fri, 2 Nov 2001 08:23:02 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.pgh.pa.us (root@[192.204.191.242]) by mailserv.hub.org (8.11.4/8.11.4) with ESMTP id fA1MZIf36623 for ; Thu, 1 Nov 2001 17:35:18 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fA1MZ7c27370; Thu, 1 Nov 2001 17:35:08 -0500 (EST) To: Oleg Lebedev cc: Postgres SQL Mailing List Subject: Re: table permissions In-reply-to: <3BE1B8CC.38221E54@waterford.org> References: <3BE1B8CC.38221E54@waterford.org> Comments: In-reply-to Oleg Lebedev message dated "Thu, 01 Nov 2001 14:04:12 -0700" Date: Thu, 01 Nov 2001 17:35:07 -0500 Message-ID: <27365.1004654107@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200111/30 X-Sequence-Number: 5415 Oleg Lebedev writes: > 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. Evidently the update is being done under privileges of user oleg. Are you using a view, rule, function, trigger, etc somewhere in there? I doubt this would happen with a straightforward INSERT typed at the command line, but if the insert command is in a rule or function owned by oleg, the game is different ... regards, tom lane