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

On Thu, Sep 24, 2015 at 9:28 PM, Alex Magnum <magnum11200@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).