Re: Grant SELECT/Execute to View/Function but not underlying Table

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thursday, September 24, 2015, 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 this

Alex

Views work this way by default.  You can specify "security definer" to get similar behavior when you create a function.

David J.