On Thu, Sep 24, 2015 at 9:28 PM, Alex Magnum <magnum11...@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/ <http://www.postgresql-consulting.com/>
