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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5146: After granting all select privelges on view to user, who still can not select the view
Дата
Msg-id 3975.1256824260@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #5146: After granting all select privelges on view to user, who still can not select the view  ("xqzhang" <zxq230104@163.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5147: DBA can not access view
Следующее
От: Euler Taveira de Oliveira
Дата:
Сообщение: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault