Re: BUG #5146: After granting all select privelges on view to user, who still can not select the view - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5146: After granting all select privelges on view to user, who still can not select the view
Date
Msg-id 3975.1256824260@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5146: After granting all select privelges on view to user, who still can not select the view  ("xqzhang" <zxq230104@163.com>)
List pgsql-bugs
"xqzhang" <zxq230104@163.com> writes:
> Description:        After granting all select privelges on view to user, who
> still can not select the view

You have a fundamental misconception about how that works.  The
privilege checks for each view are applied with respect to the owner
of that view, not the current session user.  So for example u3 needs
access to v2, not u4.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5147: DBA can not access view
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault