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