Re: Permissions + Views + Functions = relation not exist when not owner

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Permissions + Views + Functions = relation not exist when not owner
Дата
Msg-id 11686.1117029511@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Permissions + Views + Functions = relation not exist when not owner  ("Adie" <adie_xp@klub.chip.pl>)
Список pgsql-sql
"Adie" <adie_xp@klub.chip.pl> writes:
> I got a View which calls function which uses table.
> It works fine when selecting from view by owner (postgres) of table,
> function and view.
> Problem is when another user is sellecting view. There is an error:
> ERROR:  relation "XXX" does not exist

Perhaps the other user is running with a different search_path setting?
        regards, tom lane


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

Предыдущее
От: "Adie"
Дата:
Сообщение: Permissions + Views + Functions = relation not exist when not owner
Следующее
От: "hatuan"
Дата:
Сообщение: Sql select like question.