Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 29 Oct 2009 09:51:00 -0400
- Message-id: <3975.1256824260@sss.pgh.pa.us> <text/plain>
"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
- References:
- Prev by Date: Re: BUG #5147: DBA can not access view
- Next by Date: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
- Previous by thread: BUG #5146: After granting all select privelges on view to user, who still can not select the view
- Next by thread: BUG #5147: DBA can not access view
- Indexes: