Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA1KikP16202 for ; Thu, 1 Nov 2001 15:44:51 -0500 (EST) (envelope-from olebedev@waterford.org) Received: from waterford.org ([205.124.138.93]) by mail1.waterford.org (Netscape Messaging Server 3.56) with ESMTP id 424 for ; Thu, 1 Nov 2001 13:35:22 -0700 Message-ID: <3BE1B8CC.38221E54@waterford.org> Date: Thu, 01 Nov 2001 14:04:12 -0700 From: Oleg Lebedev X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: Postgres SQL Mailing List Subject: table permissions Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit X-Archive-Number: 200111/27 X-Sequence-Number: 5412 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 thanks, Oleg