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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "xqzhang" <zxq230104(at)163(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5146: After granting all select privelges on view to user, who still can not select the view
Date: 2009-10-29 13:51:00
Message-ID: 3975.1256824260@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"xqzhang" <zxq230104(at)163(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Martin Pitt 2009-10-29 14:13:21 Small syntax error in fmgr.h
Previous Message Tom Lane 2009-10-29 13:34:40 Re: BUG #5147: DBA can not access view