Re: BUG #5214: Permission troubles for views

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5214: Permission troubles for views
Дата
Msg-id 2068.1259249596@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #5214: Permission troubles for views  ("Nikolay" <wheelly@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
"Nikolay" <wheelly@gmail.com> writes:
> Description:        Permission troubles for views

> SELECT * FROM "vw_data"; - permission denied for relation tbl_data. But
> permissions say that user_b can select from tbl_data and from vw_data.

This is not a bug.  The view's reference to tbl_data is controlled by
the permissions of the owner of the view.  If it didn't work like that,
a view couldn't be used as a permissions gateway.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Nikolay"
Дата:
Сообщение: BUG #5214: Permission troubles for views
Следующее
От: "Henrik Pestano"
Дата:
Сообщение: BUG #5216: pgFouine 1.1 not working correctly, when LC_MESSAGES is "es_ES.UTF-8"