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

2015-09-24 Thread David G. Johnston
On Thursday, September 24, 2015, Maxim Boguk wrote: > > > On Thu, Sep 24, 2015 at 9:28 PM, Alex Magnum > 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? >> >

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

2015-09-24 Thread Thom Brown
On 24 September 2015 at 12:28, Alex Magnum 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 a

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

2015-09-24 Thread David G. Johnston
On Thursday, September 24, 2015, Alex Magnum 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 thei

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

2015-09-24 Thread Maxim Boguk
On Thu, Sep 24, 2015 at 9:28 PM, Alex Magnum 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 thei