Re: Grant SELECT/Execute to View/Function but not underlying Table

Поиск
Список
Период
Сортировка
От Maxim Boguk
Тема Re: Grant SELECT/Execute to View/Function but not underlying Table
Дата
Msg-id CAK-MWwT2Hzk1ZBGfOXa7=f98TRZiRFFF3eDG0PCcb-VXXnFMWA@mail.gmail.com
обсуждение исходный текст
Ответ на Grant SELECT/Execute to View/Function but not underlying Table  (Alex Magnum <magnum11200@gmail.com>)
Ответы Re: Grant SELECT/Execute to View/Function but not underlying Table
Список pgsql-general
Дерево обсуждения


On Thu, Sep 24, 2015 at 9:28 PM, Alex Magnum <magnum11200@gmail.com> wrote:
Hi,
is it possible to grant select to views and functions without the need to also grant the user the SELECT privileges to the Tables used in the views or functions?

That way I could create read only users on a website and limit their access to the bare minimum.

Thanks in advance for any advise on this

Alex


​Hi,

For functions it's possible (read about SECURITY DEFINER), for view no it isn't possible (view is query text stored in database for future use and nothing more).
​



--
Maxim Boguk
Senior Postgresql DBA
http://www.postgresql-consulting.ru/

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

Предыдущее
От: Alex Magnum
Дата:
Сообщение: Grant SELECT/Execute to View/Function but not underlying Table
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Grant SELECT/Execute to View/Function but not underlying Table