On Thu, Sep 24, 2015 at 9:28 PM, Alex Magnum <magnum11200@xxxxxxxxx> 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 thisAlex
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).
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/
Senior Postgresql DBA
http://www.postgresql-consulting.ru/
