Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4350: 'select' acess given to views containing "union all" even though user has no grants - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4350: 'select' acess given to views containing "union all" even though user has no grants
Date
Msg-id 14394.1218743213@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #4350: 'select' acess given to views containing "union all" even though user has no grants  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Responses Re: BUG #4350: 'select' acess given to views containing "union all" even though user has no grants
List pgsql-bugs
Tree view 
"Heikki Linnakangas" <heikki@enterprisedb.com> writes:
> We should use range_table_walker, which knows how to descend into all
> kinds of RTEs...

Yeah, I had been thinking of that but didn't see an easy way to apply
it; of course the answer is to use IncrementVarSublevelsUp_walker
directly as you have here.

Looks good except IncrementVarSublevelsUp_rtable really ought to have
a comment.  Please fix that, commit, and backpatch as needed.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #4355: TOKMAXLEN=10 to short for token strings
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: BUG #4350: 'select' acess given to views containing "union all" even though user has no grants