On Thursday, September 24, 2015, Alex Magnum <magnum11200(at)gmail(dot)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
>
Views work this way by default. You can specify "security definer" to get
similar behavior when you create a function.
David J.