BUG #8512: Can't use columns I can't read in the where clause of a select

From: kurt(at)roeckx(dot)be
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8512: Can't use columns I can't read in the where clause of a select
Date: 2013-10-08 18:52:18
Message-ID: E1VTcOI-0004tt-Lf@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8512
Logged by: Kurt Roeckx
Email address: kurt(at)roeckx(dot)be
PostgreSQL version: 9.0.6
Operating system: Linux
Description:

Hi,

When I read the documentation for GRANT, I see:
SELECT

Allows SELECT from any column, or the specific columns listed, of the
specified table, view, or sequence. Also allows the use of COPY TO. This
privilege is also needed to reference existing column values in UPDATE or
DELETE.

I read that as "SELECT field1 from table where field2 = 1" should work if I
have grant select(field1), but not on field2. I'm getting a "permission
denied". If I remove the where clause it of course works.

I'm not sure if the behaviour is expected or not. Maybe I'm reading the
documentation wrong, or maybe the documentation is just wrong. Could
someone please clarify?

Kurt

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephen Frost 2013-10-08 19:02:01 Re: BUG #8512: Can't use columns I can't read in the where clause of a select
Previous Message Bruce Momjian 2013-10-08 16:26:04 Re: BUG #8467: Slightly confusing pgcrypto example in docs