Re: Problem with function permission test in a view

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem with function permission test in a view
Дата
Msg-id 28477.1063299767@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problem with function permission test in a view  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Problem with function permission test in a view  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Someone asked me a question about view and function permissions.  I
> assumed all object access done by a view would be based on the
> permissions on the view, and not the permissions of the objects.

Table references are checked according to the owner of the view, but use
in a view does not change the execution context for function or operator
calls.  This is how it's always been done.

> Is this a bug?

Changing it would be a major definitional change (and a pretty major
implementation change too).  It might be better, but please don't
pre-judge the issue by labeling it a bug.
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: massive quotes?
Следующее
От: Andreas Pflug
Дата:
Сообщение: Re: massive quotes?