On Thursday, September 24, 2015, Maxim Boguk <maxim.bo...@gmail.com> wrote:
> > > On Thu, Sep 24, 2015 at 9:28 PM, Alex Magnum <magnum11...@gmail.com > <javascript:_e(%7B%7D,'cvml','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. >> >> > for view no it isn't possible (view is query text stored in database for > future use and nothing more). > > This is not how views are stored nor how they work. The are implemented as rules and thus the following section of the documentation applies. http://www.postgresql.org/docs/9.4/interactive/rules-privileges.html David J.