Postgres Pro
Downloads
Home   >   mailing lists

Re: Possible bug with permissions. (Table A has select , insert, update rights but has a reference to a second table that only has select rights) - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: Possible bug with permissions. (Table A has select , insert, update rights but has a reference to a second table that only has select rights)
Date
Msg-id Pine.BSF.4.10.10010091950140.24169-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Possible bug with permissions. (Table A has select , insert, update rights but has a reference to a second table that only has select rights)  ("Wendel Leibe" <wleibe@teamdev.com>)
List pgsql-bugs
Tree view 
It's been discussed a fair bit in the mailing lists but I don't think it's
made the documentation.  The triggers use SELECT FOR UPDATE to get the row
locks but that forces the update permission need.  In 7.1 this should be
gone (Peter E had a patch to remove the most common cases of this).

Stephan Szabo
sszabo@bigpanda.com

On Fri, 6 Oct 2000, Wendel Leibe wrote:

> I think I have found a bug with Postgres' permissions.  I have combed
> through the documentation, but I haven't been able to find an explanation
> for the following problem.
>
> First of all here is what I am running.
> Postgress version 7.0.2 ,
> OS  Linux Red Hat 6.2
> Kernel version 2.2.17
>

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: TCL, but not TK
Next
From: Tom Lane
Date:
Subject: Re: BUG in date_part