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

Поиск
Список
Период
Сортировка
От Alex Magnum
Тема Grant SELECT/Execute to View/Function but not underlying Table
Дата
Msg-id CA+cR4zf4pDRuQfrRMj4KY8w9eADXbFW7vP+eCu_aMjgQQQJ8Mg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Grant SELECT/Execute to View/Function but not underlying Table
Re: Grant SELECT/Execute to View/Function but not underlying Table
Re: Grant SELECT/Execute to View/Function but not underlying Table
Список pgsql-general
Дерево обсуждения
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

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

Предыдущее
От: maxiangqian
Дата:
Сообщение: Use tar to online backup has an error
Следующее
От: Maxim Boguk
Дата:
Сообщение: Re: Grant SELECT/Execute to View/Function but not underlying Table