Received: from ns.krot.org (ns.krot.org [193.212.103.165]) by postgresql.org (8.11.3/8.11.4) with SMTP id f9U3MUP92946 for ; Mon, 29 Oct 2001 22:22:30 -0500 (EST) (envelope-from postgresql@envisity.com) Received: (qmail 1347 invoked by uid 67); 30 Oct 2001 03:20:49 -0000 Message-ID: <20011030032049.7343.qmail@ns.krot.org> Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline MIME-Version: 1.0 From: "Aasmund Midttun Godal" To: olebedev@waterford.org Cc: pgsql-sql@postgresql.org Subject: Re: table permissions Date: Tue, 30 Oct 2001 03:20:49 GMT X-Mailer: Googley-Moogley In-Reply-To: <3BDDFBBA.99D3987E@waterford.org> from Oleg Lebedev on Mon, 29 Oct 2001 18:00:42 -0700 References: <3BDDE4F0.D5F5758E@waterford.org> <20011029235725.552.qmail@ns.krot.org> <3BDDF2FD.9FFF6B6C@waterford.org> <20011030000917.28224.qmail@ns.krot.org> <3BDDFBBA.99D3987E@waterford.org> Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id f9U3plM98340 X-Archive-Number: 200110/413 X-Sequence-Number: 5364 I don't really know a lot about these issues. However another problem I used to have (I have just avoided it for the time being, and I am getting back to it!) is corrupted users, have you messed around with pg_hba.conf? perhaps it is a problem with this. I apologize, but I don't really know. Hope someone else can help you! Regards, Aasmund. On Mon, 29 Oct 2001 18:00:42 -0700, Oleg Lebedev wrote: > I have 3 users in the database: postgres, oleg, and boss. boss is the superuser and has permissions to modify both original and referenced table. > However, when I am logged in as boss, it won't let me modify the original ('set') table unless user oleg (!!!!) has update permissions on the > referenced table ('activity'). Now I understand that I didn't have this problem before, because I just recently created this superuser boss. > > Another thing, I just noticed is that the tables I mentioned do not have permissions defined for user postgres. All the other tables in my database > do have those permissions set. Can this be the cause of the problem? > thanks, > > Oleg > > Aasmund Midttun Godal wrote: > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly Aasmund Midttun Godal aasmund@godal.com - http://www.godal.com/ +47 40 45 20 46